Skip to Main Content

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!

table_exists_action=truncate is not importing all the constraints set on the table being imported.

Sai ChallaOct 27 2015 — edited Nov 2 2015

I am trying to import multiple tables from one database to another using impdp. During the import I got a lot of "ORA-39153 Table "schema"."table_name" exists and has been truncated. Data will be loaded but all dependent metadata will be skipped due to table_exists_action of truncate" errors. But, the import went fine and all the rows were imported successfully. However, when I tried to list out all the constraints and compare them with the constraints of the target table I found some that some of the constraints (Primary Keys ) were not imported. Is this expected ? Can you also let me know a way to bypass this issue ? I basically need to import all the data from my production database to the DR (backup) database using impdp.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 30 2015
Added on Oct 27 2015
6 comments
5,186 views