Expdb and Impdb for table with different name and schema

Expdb and Impdb for a table with different name and schema

Expdp and Impdp is the logical oracle backup utility. It is used for logically backup of the database.

Esample: we take backup of table EMPLOYEE in SCOTT schema from the production environment and import the table in new schema HR and changed table name as HR_EMPLOYEE

1. Expdp for the table from the primary database

expdp directory=datapump1 dumpfile=expdp_table.dmp logfile=expdp_table.log tables=SCOTT.EMPLOYEE

2. Impdp the table with different name and user in Test Environment

impdp  REMAP_SCHEMA=SCOTT:HR REMAP_TABLE=EMPLOYEE:HR_EMPLOYEE directory=datapump1 dumpfile=expdp_table.dmp logfile=impdp_table.log

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.