IMPDP of specific table with replace option

Replace the tables with impdb datapump which is already present in schema

Create a directory dbbackup1 where your dump file is placed for import operation.

create directory dbbackup1 as 'D:\dumpfile';

Grant read, write permission on directory to scott user:

grant read, write on directory dbbackup1 to Scott;

Import the table which is already exists in the database with the replace option of TABLE_EXISTS_ACTION parameter otherwise import process will generate the error that table is already exists in the database.

impdp directory=dbbackup1 dumpfile=SCOTT_DUMP.DMP logfile=SCOTT_DUMP_IMP.log
tables=SCOTT.INVOICE_GENERATION_TIME, SCOTT.POS_GROUP_IDS
TABLE_EXISTS_ACTION=replace

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 )

w

Connecting to %s

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