SQL & PL/SQL

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!

Unique Constraint errors in IMPDP

NevinJul 21 2011 — edited Jul 22 2011

I'm getting a lot of unique constraint errors when I'm importing using IMPDP. Below is my par file. Is there anything I can do to avoid these errors other than disabling the constraints? Disabling them just seems like it would cause me more problems later when I tried to re-enable them.

Thanks in advance.

DUMPFILE=export.dmp
LOGFILE=import.log
TABLE_EXISTS_ACTION=TRUNCATE
CONTENT=DATA_ONLY
SCHEMAS=TEST

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 19 2011

Added on Jul 21 2011

12 comments

3,705 views