Thanks a lot friends,

Ya external table is a good option but i am having oracle 8.1.5, so that option is not feasible at this juncture. Direct = true is a good option to load data fast.

My other query is, while loading data can i load master and detail data simaltaneously into Parent/Child table, i only want to insert one row in parent table and to load all records of flat file into child table.

Parent table will have a file_name, upload_Date and child table will have all records of flat file.

Since i am calling this sqlloader from Shell scripts i can not write insert statement for parent table before loading, because once i call shell scripts i am not having any control on sqlloader thread.

Can u suugest me how to fulfill my requirement via SQLloader to load in Parent and Child table.


Thanks in advance

With Regards

Hitesh Parikh