Dear
One of the solution is you can export in system user with two
user tables. You can exp/ imp blob column also. Later you can imp thru
system, but use from user and to user options.
I think it will help u.
Thanks and Regards
V.Baskaran
-----Original Message-----
Ciocildau
Sent: Tuesday, October 29, 2002 11:18
To: Multiple recipients of list ORACLE-L
Hello,
I have a problem and I hope you can help me.
We have a Oracle 9 installation two users with two different default
tablespaces. The problem is to move data between theese two users with
imp/exp.
I'll try to explain it a little bit more.
we have userA with the default tablescape tabA and userB with tablB.
first we want to do something like:
exp userA/passA owner=(userA) file=dump.dmp
and after:
imp userB/passB fromuser=(userA) touser=(userB) file=dump.dmp
If we do not have BLOB columns everything works fine. I think the
problem resides in the fact that in the case of a BLOB column the
STORAGE clause specifies in which tablespace the BLOB column
should be stored and this is not handled by the imp program (not
relocated in the tablespace B).
I'm sure there should be a way to handle this but I was not able
to find it.
Please help.
Adrian
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Adrian Ciocildau
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Oracle
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
