ORA-01436: Script for the child tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01436: Script for the child tables

  1. #1
    Join Date
    Aug 2000
    Posts
    194
    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,

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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 Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width