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!

Datapump - Import Whole Database and Replace Current Data

RamarajuAug 9 2016 — edited Aug 11 2016

Hi,

We have 2 databases. One is prod and 2nd is Test.

We need to import Prod database full dump file into Test. We have already having all schemas but, some records modified.

How to import whole database and replace current data?

Can I use TABLE_EXISTS_ACTION=APPEND ? Is this safe to use?

Please advise.

Thanks,

Ramaraju

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2016

Added on Aug 9 2016

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

10 comments

2,934 views