Home » RDBMS Server » Server Utilities » importing dumpfile (oracle,, AIX6.1)
importing dumpfile [message #555686] Sun, 27 May 2012 05:22 Go to next message
Messages: 33
Registered: May 2010

I have taken the backup of a1111@prod user using the below command. User was added to default tablespace to AA.
exp a1111/a1111 file=a1111.dmp log=a1111.log compress=y

Now I am trying to import the dump into another user b1111@dev. User was added to default tablespace to BB.
Here in this dev database also I have the same tablespace AA. But the user b1111 is maappped to BB tablespace.
When I have tried to import the dump a1111.dmp into b1111 all the objects are getting imported into AA tablespace itself
but i want these objects to be imported into BB tablespace. Used the below command to import.
imp b1111/b1111 file=a1111.dmp log=a1111_imp.log full=y ignore=y grants=n commit=y resumable=y

Please suggest what needs to be done to import the a1111.dmp objects into BB tablespace? Thank you.
Re: importing dumpfile [message #555688 is a reply to message #555686] Sun, 27 May 2012 05:40 Go to previous message
Messages: 21810
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you have used Data pump export (instead of the original export utility), then you could have used REMAP_TABLESPACE Data pump import's parameter (which is designed for what you are looking for).

Read Can one import tables to a different tablespace? on OraFAQ Wiki.
Previous Topic: Datapump import and Referential Integrity constraints
Next Topic: export/dump with expdp for non-privileged users
Goto Forum:

Current Time: Tue May 21 05:00:06 CDT 2024