Hi Friends,

It is very long time since i visited this form. i am looking for some idea because of functionality restrictions to replace foreign key with on delete cascade --to--> trigger in 10g.

eg:
we have two tables dept and emp table.
emp table has foreign key with on delete cascade enabled

---

now we want to get same functionality by removing this foreign key but still having delete cascade between emp and dept .

please let me know if this possible
after removing foreign key . child records should be deleted when parent is deleted .


actual setup is i have 1 table grp with 5000 child tables having foreignkey pointing to single column in grp table.

Thanks fro your help.
Siva prakash