is it possible to force a cascade delete if i ve not initialized during the creation of the intergrity cascade delete?
Write a detail, What do u want ?
I have 2 tables all related to each other in some way
when i try to delete the contenst of 1 table it says" child in other " so cannot delete
in the 2nd table if i try to insert..it says "record not found in 1st table cause 1 feild related to a column in first table
Now i get a file every 15 days for thses updates and delete
1 file for each table
he file contains the delete and insert statements
if i try to execute the 1st file it inserts properly but cannot delete as child xists
if i try to execute 2nd first it deleted properly but cannot insert as primary not fiund..
i hope u c what the problem is
i can drop the constraint and recreate it
but is there ay other way out?
alter table disable constraint name;
when done with your alterations, ENABLE the constraint(s) again.
normally spooling a disable script and an enable script is very helpful by selecting from dba_constraints where owner = schema you have your tables under.
that make sense?
Click Here to Expand Forum to Full Width