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

CLSR-00528: RACGONS: host and port number already configured in OCR

1 Answers  


ORA-39103: Timeout before worker process string finished initialization. Worker error:

1 Answers  


ORA-06123: NETTCP: cannot set KEEPALIVE

1 Answers  


RMAN-07500: searching for all files that match the pattern string

1 Answers  


ORA-29884: domain index is defined on the column to be dropped

1 Answers  






TNS-04023: Command failed.

1 Answers  


ORA-34350: (MXDSS06) string is an open analytic workspace.

1 Answers  


ORA-16216: Log stream sequence error

1 Answers  


ORA-24804: Lob read/write functions called while another OCI LOB read/write streaming is in progress

1 Answers  


ORA-16163: LGWR network server host attach error

1 Answers  


ORA-13237: internal error during R-tree concurrent updates: [string]

1 Answers  


ORA-12062: transaction string received out of sequence from site string

1 Answers  


Categories