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

ORA-32103: error from OCI call

1 Answers  


ORA-27155: could not execute file

1 Answers  


ORA-33054: (XSAGDNGL26) In AGGMAP workspace object, a MIN argument of number must be less than a FLOOR argument of number.

1 Answers  


ORA-29836: failed to validate referenced operators

1 Answers  


TNS-00527: Protocol Adapter not loadable

1 Answers  






RMAN-06470: DEVICE TYPE is supported only when automatic channels are used

1 Answers  


DRG-10827: open_con must be performed before count_last

1 Answers  


ORA-38447: Type required for the embedded ADT attribute "string" is missing

1 Answers  


ORA-24080: unschedule_propagation pending for QUEUE string and DESTINATION string

1 Answers  


ORA-23491: no valid extension request at "string"

1 Answers  


DRG-51024: out of memory in stemmer

1 Answers  


RMAN-00571: ===========================================================

1 Answers   HCL,


Categories