How to rename multiple table names with REMAP_TABLE

oracle remap datapump
Meisam picture Meisam · Jan 29, 2017 · Viewed 19.3k times · Source

I have a dump file which contains several tables (A, B, C).

How can I rename these tables (A -> x, B -> y, C -> z) during data import?

Answer

Meisam picture Meisam · Jan 29, 2017

Remapping multiple table names is possible with comma separated table names as following example:

impdp user/pass directory=my_dp_dir remap_schema=src_schema:dest_schema
REMAP_TABLESPACE=src_ts:dest_ts
REMAP_TABLE=src_schema.A:x,src_schema.B:y,src_schema.C:z
dumpfile=dump_file.dmp logfile=impdp.log

Related questions

Is there a good workaround to the Oracle IMPDP REMAP_SCHEMA issue with triggers (ORA-39083, ORA-00942)?

One can use the Oracle data pump import tool (IMPDP.EXE) to import one schema into another using the REMAP_SCHEMA option. However there is an issue in that triggers are not properly remapped. This leads to the trigger not …

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More