how to generate a script for table insertion in the correct

[kytemaniac]

Hi,

how should I generate a script for table insertion in the correct order.

let's say there's table A, B, C all with parent child relationship as follows C is the parent of B and B is the parent of A.

understand that there's a table called dba_dependencies but I still could not figure out how to make use of this data dictionary to generate the insert tables in the correct order.

thanks a lot!

[Tim...]

Hi.

I think the best route through this is to use the DBA_CONSTRAINTS view to link the tables together in a free walk. Just be careful as circular references can break things.

Cheers

Tim...