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 replace with foreign keys

Merlin128Mar 6 2014 — edited Mar 6 2014

I tried an impdp with table_exists_action=replace

ORA-39120: Table "TABLENAME" can't be truncated, data will be skipped. Failing error is:

ORA-02266: unique/primary keys in table referenced by enabled foreign keys

If I do APPEND instead of REPLACE, it will get the new records, does it also update edited or deleted records?

actually what I am needing is to pull data from a schema in one database to another database nightly:

system/******** DIRECTORY=EXPORT schemas=SCHEMA_NAME table_exists_action=replace network_link=DB_LINK logfile=LOG.log
This post has been answered by Merlin128 on Mar 6 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 3 2014
Added on Mar 6 2014
#database-key-features, #export-import-sql-loader-external-tables
2 comments
2,188 views