Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-02292: integrity constraint (string.string) violated -
child record found

Answers were Sorted based on User's Feedback



ORA-02292: integrity constraint (string.string) violated - child record found..

Answer / guest

Cause: attempted to delete a parent key value that had a
foreign key dependency.

Action: delete dependencies first then parent or disable
constraint.

Please add more information about this Error

Is This Answer Correct ?    5 Yes 1 No

ORA-02292: integrity constraint (string.string) violated - child record found..

Answer / muhannad

im changing the parent key value which is a child key in
different table, i want the child key to changed as well
when i change the parent key.
thanx

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-10000: failed to read column string.string

1 Answers  


ORA-07489: scgrcl: cannot get lock status.

1 Answers  


RMAN-20250: offline range not found in the recovery catalog

1 Answers  


SQL*Loader-00260: TERMINATED BY EOF option available only with LOBFILE option

1 Answers  


ORA-25467: table alias not specified

1 Answers  






ORA-25457: evaluation function string returns failure

1 Answers  


ORA-02202: no more tables permitted in this cluster

1 Answers  


PCB-00216: OCCURS ASCENDING/DESCENDING clause not allowed for "string"

1 Answers  


NZE-29033: Invalid PFX

1 Answers  


ORA-02167: LOGFILE clause specified more than once

1 Answers  


PLS-01410: Use of 'MOD' token

1 Answers  


ORA-10920: Cannot offline tablespace belonging to default temporary tablespace group

1 Answers  






Categories