RE: imp issue...very confusing!

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Tue, 13 Jul 2004 10:51:42 -0400
Message-ID: <002b01c468e8$e9223110$8459699f@vttaxnet.tax.state.vt.us>

You can get around this by making the touser tablespace his default tablespace.

HTH,
Ruth

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Smith, Ron L. Sent: Tuesday, July 13, 2004 10:37 AM
To: oracle-l_at_freelists.org
Subject: RE: imp issue...very confusing!

I found that when I give a user (touser) unlimited tablespace on his/her own tablespace, for some reason the user also gets granted unlimited tablespace on all tablespaces. When that happens, the fromuser touser option results in all the objects getting put back into the fromuser tablespace. When I revoke unlimited tablespace, the import works fine.

Ron Smith

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Denham Eva Sent: Tuesday, July 13, 2004 9:33 AM
To: oracle-l_at_freelists.org
Subject: imp issue...very confusing!

Hello Gurus,

Here is the situation, I have a Oracle 7.3.4 dump, which am importing into a Oracle 9.2 server, both Windows platforms. I created a new user "schema" for the data, with it's own tablespace etc. No fancy imp parameters other than fromuser, touser.

Here is my problem, the fromuser does already exist on the server with its data from the 7.3 server. So the import is now happily importing the data but into the fromuser tablespace and not into the touser's tablespace as I had wanted it to. The touser is now the owner, but naturally the tablespace of fromuser has began to grow huge.

Why is this? I have rtfm-ed the docs. I don't really get any answers as it speaks of transport_tablespace, but I don't think this is quite the option I would require.

Has anyone got any ideas?

Many Thanks
Denham

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Jul 13 2004 - 09:49:32 CDT