Skip to Main Content
Forums

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!

Impdp and Table Exists Action

kirkladbApr 16 2013 — edited Apr 16 2013
I have no clue why I don't know this but when you import say a schema from one instance to another and you only want to overwrite data in the target (and leave all pl/sql procedures alone), what are the impdp commands to do this. I first thought the following would do the trick:

impdp .... table_exists_action=REPLACE

But then I second guessed myself and thought the following might work....

impdp .. table_exists_action=REPLACE content=DATA_ONLY

I guess I could do a test, but I thought about all the smart folks on this forum and decided to ask you guys first. Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2013
Added on Apr 16 2013
#database-key-features, #export-import-sql-loader-external-tables
3 comments
44,731 views