delete from table question

2002-07-16 Thread dmeng
Hi All - I am trying to delete from a table that has 24 child tables. Because the constraints are not 'cascade delete', I am hitting the following: ORA-02292: integrity constraint (NVALET.FK_TOPOGROUPMEMBERNE2) violated - child record found If I want to go ahead and delete the child records as

RE: delete from table question

2002-07-16 Thread Inder . Singh
Hi, I have this script which deletes the record from the master as well as all the Child tables also. May be this will help you. But I have never used this script before. Check this on Development before running it in Prod. To delete records from all the dependent tables and the master table