-
Hi,
I am trying to delete a contacts table using the following command but it gives me an error
1* delete from contacts cascade where contact_id=56123
SQL> /
delete from contacts cascade where contact_id=56123
*
ERROR at line 1:
ORA-02292: integrity constraint (COMPANY.SYS_C0029597) violated - child record
found
why doesnt the cascade option work in this case.
Ronnie
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|