O'Reilly logo

Oracle Database 12c Backup and Recovery Survival Guide by Aman Sharma, Francisco Munoz Alvarez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required