Load csv files into DB: What is the best tools (sqlldr ?)
Hello,
We are in 11gR1 ...and I have just practiced easy SQLLDR import ... So I feel quite new in the domain.
We got a special situation because, in our Unix DB server, we receive CSV files with, at their first line, the column titles, ..
These CSV have their columns never at the same place ... and we experience difficulties to import their data... (multiple CTL, many errors and maintenances) :
The column titles are the same, but not their position in the file...
We have first thought about using sqlldr to import these files ... but (from another thread) this situation force us to have multiple CTL files (please see the examples below).
But maybe we are not using the best tools for this specific situation ?
Shall we use another tools for importing CSV files into our Oracle tables ?
-----
Here are small examples :
CSV1 :
Project;Customer;Title *;Description *;Submitted By;Submitted On
Maintenance 1 2 3;CUST_A;Analysis;Description of the Analysis;Bob Dylan;19/08/2008
Maintenance B;CUST_B;Development;Description of the project;Bob Dylan;19/08/2008
...
CSV2 :
Title *;Description *;Project;Customer;Submitted On;Submitted By
Admin; Description of Administration; Proj1; Cust_A; 25/12/2008; Prince
...
CSV3 :
Description *;Customer;Title *;Project;Submitted By;Submitted On
Desc profile;Cust_B;Analysis;Projet_A; Phil Collins; 11/03/2009
...
-----
I hope that my explanation is clear enough ...
Thanks in advance for your help,
Olivier