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!
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.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 2 guests