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-32037: unsupported use of LEVEL in membership condition

1 Answers  


ORA-19960: Internal use only

1 Answers  


PLS-00209: table 'string' is not in FROM clause

1 Answers  


ORA-32404: snapshot log uses Change Data Capture which is not enabled for this database

1 Answers  


SQL*Loader-00646: lob set to EMPTY in column string, row number, table string

1 Answers  






NNL-00901: CONTENT ERROR responses sent: number

1 Answers  


DRG-11706: invalid relation string

1 Answers  


DRG-11847: Revalidation Failed

1 Answers  


LFI-00115: Buffer free failed.

1 Answers  


IMG-00560: input format does not support page selection

1 Answers  


ORA-07700: sksarch: interrupt received

1 Answers  


NZE-28804: Data source cannot close.

1 Answers  


Categories