Home » RDBMS Server » Server Utilities » changing tablespace during import (oracle 9i , solaris)
changing tablespace during import [message #378452] Tue, 30 December 2008 08:27 Go to next message
koff10
Messages: 58
Registered: December 2006
Location: france
Member
Hi all,
I'm trying to import datafile based on tablespace A
to user where default tablespace is B .
But after import, the destination user get data on tablespace A instead of tablespace B
how can I do to keep data on tablespace B for my destination user
Thanks all
koff
Re: changing tablespace during import [message #378462 is a reply to message #378452] Tue, 30 December 2008 09:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
May be the resource role is been granted to for destination user.
If granted, it would allow the user to write to any available tablespace.
During Import, the table definitions are read.
If the same tablespace exists in destination also, then the tables will be created in same tablespace.
So, revoke resource role, make only tablespace B as default for destination user with unlimited/limited quota and do the import.
If required, grant resource again after import.
Re: changing tablespace during import [message #378474 is a reply to message #378462] Tue, 30 December 2008 10:00 Go to previous message
koff10
Messages: 58
Registered: December 2006
Location: france
Member
thanks for the solution
koff
Previous Topic: IMp-00010 during export
Next Topic: SQL Loader - extra field in data file, but need to use its value for another field
Goto Forum:
  


Current Time: Thu Dec 08 00:17:37 CST 2016

Total time taken to generate the page: 0.14268 seconds