oracle-databaseoracle-dump

IMPDP remap_schema multiple files

Here is the correct syntax for a single schema IMPDP rename :

impdp system/**** directory=DATA_PUMP_DIR dumpfile=export_something.dmp logfile=imp.log remap_schema=name:newname

How would you import multiple schemas from one export while remapping them? Will this work?

impdp system/**** directory=DATA_PUMP_DIR dumpfile=export_something.dmp logfile=imp.log remap_schema=name:newname,name2:newname2,name3:banana

Solution

  • I just tried IMPDP REMAP_SCHEMA on a live oracle instance and it works with the above syntax.

    You must only keep in mind these things :

    -You can't remap the same schema under different names at once (For that impdp it multiple times)

    -The schema names have to be in your export (of course)