Re: Delete child-parent records???????

traineensp_at_softcell.co.in (Divya) wrote in message news:<c343a42.0306222019.6cd519c9_at_posting.google.com>...
> Hi,
>
> I am using Oracle 8.1.4.x and have few records already stored in few
> tables that share the referential integrity property....
>
> Now there is some major error in the frontend display for which i
> want to redo the entire display for which i need to first delete those
> records....But i am unable to delete hem freom either of those
> tables...I get the error message: -
>
> Error at Line 1:
> ORA 02292: integrity constraint (NSPAPP.sys_C006184)violated -
> child record found.
>
> Pls help me out...
> If i have emailed at the wrong zone pls guide me to the oracle newbie
> groups also then....
> Thanks in advance,
>
> Divya

Disable the constraint, delete the rows, reenable the constraint.

See the SQL manual for ALTER TABLE to see how to enable and disable constraints. I would recommend you consider dropping and recreating the constraints giving them names you choose rather than system generated names as above.

You can query dba_constraints to see all constraints defined against a table. Foreign keys have a constraint_type of 'R'.

HTH -- Mark D Powell -- Received on Mon Jun 23 2003 - 15:23:52 CEST