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


Leave a Reply

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

You are commenting using your 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.