SQL & PL/SQL

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-02292: integrity constraint (% %) violated - child record

user1117837May 6 2011 — edited May 6 2011

Hi,

I am getting the below message when I try to delete record in the parent table.

"ORA-02292: integrity constraint (SMI.SYS_C0018867) violated - child record found"

I know this merror is due to refrential integrity but when checked in the child table I don't have any dependent records.

Did any one encounter this error if yes and have more details can you please let me know. I am using Oracle 11g

Thanks,
Prashanth

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 3 2011

Added on May 6 2011

5 comments

9,439 views