Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMPDP remap many schemas?

846231Aug 15 2012 — edited Aug 17 2012
Hi all,

11.2.0.1

I want to import 3 schemas but they need to be remapped to a another schemas, Is this possible in one import run? (kindly answer yes or no )

IMPDEP SYSTEM/MANAGER SCHEMAS=HR,FA,CM REMAP_SCHEMA=HR:HR_NEW,FA:FA_NEW,CM:CM_NEW


Is this correct?


Thanks a lot,

Kinz

Edited by: KinsaKaUy? on 15-Aug-2012 06:05
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2012
Added on Aug 15 2012
#database-key-features, #export-import-sql-loader-external-tables
8 comments
397 views