imp/exp question

From: Adrian Ciocildau <adri_l_at_gmx.net>
Date: Tue, 29 Oct 2002 00:18:27 -0800
Message-ID: <F001.004F5DD2.20021029001827@fatcity.com>

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). Received on Tue Oct 29 2002 - 02:18:27 CST