Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Equivalent of TABLE_EXISTS_ACTION=REPLACE in imp

CastellDec 12 2017 — edited Dec 14 2017

DB version: 11.2.0.4

I am using original imp utility. I have a few tables in my export dumpfile and I need to import it to a schema which already has these tables.

While importing , I want to drop the existing tables in the schema and import the tables from the dump file. ie I am looking for the equivalent of TABLE_EXISTS_ACTION=REPLACE in expdp.

Any idea what it is ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 11 2018

Added on Dec 12 2017

#database-key-features, #export-import-sql-loader-external-tables

6 comments

10,508 views