Oracle Database 12c Backup and Recovery Survival Guide

Moving an object to a different schema

To be able to move objects in one schema to a different schema, all you need to do is to use the parameter REMAP_SCHEMA when importing it, as shown in the following command:

$ expdp fcomunoz/alvarez@pdborcl tables=test.employee directory=datapump dumpfile=employee_06192013.dmp

$ impdp fcomunoz/alvarez@pdborcl directory=datapump dumpfile= employee_06192013.dmp remap_schema=test:test2

Note

If all you want to do is to move a table or a group of tables, remember to use the parameter TABLES to achieve this goal; you can also use the INCLUDE and EXCLUDE parameters to filter the data to be moved even more.