ORA-01436: Script for the child tables

[gsprince]

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

Thanks,

[jmodic]

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,