Home » RDBMS Server » Server Utilities » Load mutiple tables using SQL loader
Load mutiple tables using SQL loader [message #416898] Wed, 05 August 2009 01:11 Go to next message
coolguy01
Messages: 64
Registered: August 2006
Member
Hi ,
I am trying to load multiple tables using a single .csv file. I am aware that this is possible with SQL loader but I was wondering if it would let me split the data into different tables based on columns. For example if my .csv file has 15 columns can i specify first 5 columns go to table 1, next 5 columns go to table 2 and remaining columns to table 3. Would SQL loader allow me to split the data based on columns ? If yes could someone provide me an example of the control file or if not an alternative of doin so.

Thanks and Regards
Re: Load mutiple tables using SQL loader [message #416900 is a reply to message #416898] Wed, 05 August 2009 01:12 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Specify 3 times INTO part with different columns.

Regards
Michel
Previous Topic: Dynamic schema and tables name in dbms_datapump
Next Topic: SQLLoader date formatting help
Goto Forum:
  


Current Time: Wed Dec 07 16:38:57 CST 2016

Total time taken to generate the page: 0.24012 seconds