Load mutiple tables using SQL loader [message #416898] |
Wed, 05 August 2009 01:11 |
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
|
|
|
|