The sql-loader tag has no wiki summary.
2
votes
2answers
121 views
Loading XML documents to Oracle 11g DB with control file
I am using Oracle 11g XML database and trying to load XML documents to this DB with a control file and the sqlldr utility. All these XML files have an element that contains a date string with time ...
3
votes
1answer
161 views
Load Numerical Column with Variable Comma
I'm using sqlldr to load a file which has a numerical value as one of its fields.
The problem is that in some of the records the number has commas whereas in other, it doesn't.
So doing something ...
2
votes
1answer
413 views
Oracle SQL Loader - load file where record is composed of “n” delimiters
How would you write a control file for Oracle SQL Loader that treats each record as being composed of 3 commas?
I have read the documentation, however I cannot find how to handle this scenario, ...
1
vote
1answer
482 views
Use sqlldr control file to automatically create several tables in Oracle
I have a client who has a requirement that I load data from csv files into an Oracle database. Part of the requirement is that I use sqlldr and provide a control file to facilitate loading this data. ...
3
votes
1answer
3k views
SQL*Loader-605: Non-data dependent ORACLE error occurred
As I try to load data into Oracle, I've encountered SQL*Loader-605: Non-data dependent ORACLE error occurred error.
Data is (are?) in .txt file and its size is 95GB.
Here are some more details ...
