I am going to create flatfiles from my db using dbms_util file package. Once I create them I am going to create tables and dump them into tables using Sql loader.. I will definitely have problems with constraints and so on..
Is there any efficient way to find out all children tables first and then parent tables.. so that I can load sequentially..
The reason why I am doing this is basically, be able to alter the structure (as a part of upgrade) if any and then load data.
Thanks..