Thanks Vijay for taking time to respond..But i am loading data using federated database. So these are just INSERT statements based on query getting data from federated database. So can i use LOAD utility using cursor..But i know there will be lot of constraint violations. According to yr advise, i will again have to load all the exceptions. Pls let me know if i m missing something...

Hi Experts..I am trying to create data load process . I have bunch of different queries to load data in around 400 tables. I want to load the data in parent-child tables order to avoid any constraint violation. So if hit a table, first i want to find all the parents and child for that and start loading data from parent all the way down to child..I have having hard time achieving it. Any help is appreciated..If somehow i can develop a view with tables...