Loading data from Flat files

From: Abhishek Gurung <abhishek.gurung_at_hotmail.com>
Date: Tue, 20 Dec 2011 15:17:51 +0530
Message-ID: <BLU159-W59F762021D17D9E4990205EAA40_at_phx.gbl>



Hi

Scenario:

1. I have to load data into oracle from multiple large flat flies and XML.
2. Each flat file contains data of multiple table.
3. Structure of flat file is like this

system_variable TableName:Column1_Name="Value", Column2_Name="Value", Column3_Name="Value".......................ColumnN_Name="Value";


4. Only Changed/Added columns are available in file for that particular table.

 Question: What is the best method to load data from these files to Oracle tables?

Regards
Abhishek Gurung                                                

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 20 2011 - 03:47:51 CST

Original text of this message