SQL*Loader is a bulk loader for Oracle
1
vote
1answer
195 views
Example of loading into RDS from S3 using SQL*Loader
Does anyone have a working sample of loading data into an Amazon AWS RDS Oracle database using SQL*Loader where the source file is on S3?
In principle it's clearly possible. The Amazon RDS Data ...
2
votes
2answers
186 views
How make convincing case to DBA to use Oracle external tables for 500 MB to 5 GB files?
In our data feeds, we have a stack of XML files as well as numerous flat files to put into an Oracle11g database. We flatten the XML into delimited files, and load the whole set using SQLLoader.
I ...
2
votes
2answers
552 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
386 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
512 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
653 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 ...
