Re: [Q] Load (or delete) order

Well,
I did not hear any responses sofar. So I guess there is no script like that. I was also told that Oracle does not provide any program that helps in that area. I am surprised, it seems like figuring out dependencies amongst tables is something a lot of people would be interested it.

Anyways, I solved this by writing a C program that builds a dependency tree structure. And then prints out notes on each level.
Each node is either a parent or a child. A parent node represents a table that needs to be populated before a child table can be populated. Parent-Child relation ship can be obtained from user_constraints. Once the tree is built if traversed from top level to bottom -- table names for the load order will be printed, and the delete order is just a reverse of load.

Vladislav

<vladik854_at_my-deja.com> wrote in message news:7ond1k$vtc$1_at_nnrp1.deja.com...
> Hello,
> does anyone know of a script that can figure
> out the load (or delete) order for oracle tables
> We have a lot of tables with tons of referential integrity
> constraints and I need to know the order at wich I have
> to delete tables (it is a reverse of load order)
>
> I know that there is a way to do that because Oracle importer
> does the same things when loading tables .
>
> Thanks in advance.
> If, possible, I would appreciate an e-mail
> back at vlpa_at_daleen.com
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Aug 13 1999 - 20:14:51 CDT