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

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.

Report message to a moderator

Re: importing dumpfile [message #555688 is a reply to message #555686] Sun, 27 May 2012 05:40 Go to previous message
Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic: Datapump import and Referential Integrity constraints
Next Topic: export/dump with expdp for non-privileged users
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 03 16:21:50 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.