-
Hi:
Does anyone knows/have some scripts which will list all the dependent Tables of a given Table, in the HIERARCHICAL order? (I will use the generated table to delete the child table records then the parent's and so on)
I tried the one from Metalink (DocID: 1039304.6), but getting the error "ORA-01436: CONNECT BY loop in user dat".
If anyone has such a script, would you please send me to "[email protected]"
Thanks,
-
On Metalink, enter "TABLE DEPENDENCIES TFTS" as a search string (TFTS stands for "Tales From The Scripts", an old collection of usefull scripts that Oracle developers have published "unofficialy" for use at the user's own risk...). You'll get a couple of hits. I think the one with DOC id 1020089.6 will do exactly what you want....
HTH,