Re: imp/exp question

Hi,

what do you mean with "to export in system user with two user tables" ?

Regards,

Adrian Ciocildau

Oracle wrote:

>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: adri_l_at_gmx.net

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: ListGuru_at_fatcity.com (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).