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!

Integrity constraint errors while loading the data

hsemarJan 23 2019 — edited Jan 24 2019

Hi,

Either using datapump or conventional import is there any mechanism to resolve the integrity constraint errors. I mean load the data ignoring the foreign key constraints. Disabling and Enabling constraints becoming a big pain and i can't want to do this all the time. Any utility to ignore the data or wait until all the data load.

fyi.,

imp file=3d634tdy.dmp fromuser=3d634tdy touser=3d634tdy indexes=n constraints=n grants=n data_only=y log=imp_first.log

I could see plenty of errors

ORA-02291: integrity constraint (3d634tdy.FK1_EVENT) violated - parent key not found

Regards,

Ramesh G

Added on Jan 23 2019

#oracle, #sql

3 comments

332 views