If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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 "pkumar@intacct.com"

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,

Jurij ModicASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?