imp issue...very confusing!
- From: "Denham Eva" <EVAD@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Jul 2004 16:33:28 +0200
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
