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
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-lReceived on Tue Dec 20 2011 - 03:47:51 CST