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!

How to avoid parent key not found

unknown-1052419May 16 2014 — edited May 16 2014

Hi All,

11.2.0.3

I wan to load table data even if its parents key is not found. That is why I am disabling all constraints before I do import.

But still I hit the error. Or was it not disabled after all?

ORA-31693: Table data object "INST_SUPP_TRANS" failed to load/unload and is being skipped due to error:

ORA-29913: error in executing ODCIEXTTABLEFETCH callout

ORA-02291: integrity constraint (FK_INST_SUPP_TRANS_CNTRLID) violated - parent key not found

Thanks,

pK
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2014
Added on May 16 2014
#database-key-features, #export-import-sql-loader-external-tables
2 comments
1,735 views