Skip to Main Content
Forums

Oracle Database Discussions

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!

ORA-02291: integrity constraint violated-parent key not found

899401Aug 7 2013 — edited Aug 7 2013

Hi,

while executing query i am getting below mentionmed error

ORA-02291: integrity constraint violated-parent key not found

I AM NOT ABLE TO FIND WHICH IS THE PARENT TABLE.please find below mentioned below mentioned realtionship for the same

ODS_TSAF_MES_PC_FK1Foreign_KeyMES_ODSODS_TSAF_MES_PCODS_TSAF_MES_PC_PKNO ACTIONENABLEDNOT DEFERRABLEVALIDATEDUSER NAME
ODS_TSAF_MES_PC_FK2Foreign_KeyMES_ODSODS_TSAF_MES_PCTYPODS_TSAF_MES_PCTYP_PKNO ACTIONENABLEDNOT DEFERRABLEVALIDATEDUSER NAME
ODS_TSAF_MES_PC_FK3Foreign_KeyMES_ODSODS_TSAF_MES_PCSTATODS_TSAF_MES_PCSTAT_PKNO ACTIONENABLEDNOT DEFERRABLEVALIDATEDUSER NAME
ODS_TSAF_MES_PC_PKPrimary_KeyENABLEDNOT DEFERRABLEVALIDATEDUSER NAME
SYS_C006092Check"PIECEKEY" IS NOT NULLENABLEDNOT DEFERRABLEVALIDATEDGENERATED NAME
This post has been answered by unknown-7404 on Aug 7 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 4 2013
Added on Aug 7 2013
#general-database-discussions
11 comments
2,111 views