How to Rename Multiple Table Names with Remap_Table
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? 1 Answer Remapping...
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?
1 Answer
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
Marcus Vance is a cybersecurity auditor and technology writer dedicated to educating the public about online safety, data privacy regulations, enterprise security, and emerging cyber threats.
