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 "firstname.lastname@example.org"
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....
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Click Here to Expand Forum to Full Width