Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sql-loader]

SQL*Loader is a bulk loader for Oracle

SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database.

Credit: http://www.orafaq.com/wiki/SQL*Loader_FAQ

28 questions
4
votes
1 answer

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. However there are a lot of text files with a lot…
Phil
  • 141
  • 1
  • 3
4
votes
2 answers

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 want to try a proof-of-concept loading via TABLE…
Andrew Wolfe
  • 584
  • 5
  • 16
4
votes
2 answers

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 stamp (and the letter T in the middle of it). …
Asif
  • 41
  • 1
  • 4
4
votes
1 answer

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 like num "to_number(:num, '999,999,999.99')", loads…
Isaac Kleinman
  • 520
  • 3
  • 7
  • 13
3
votes
1 answer

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 about the error: value used for ROWS parameter changed…
Mehmet Balioglu
  • 340
  • 2
  • 7
  • 13
3
votes
1 answer

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 Import Guide for Oracle documents using sqlldr. But the…
mdahlman
  • 357
  • 3
  • 14
3
votes
2 answers

NLS_NUMERIC_CHARACTERS in SQL loader control file

I am using a Control File to import data from a CSV file into a table, using sqlldr to import the data, where a large number of fields are numeric values with integer and decimal part separated by dots. The Control File works just fine because I…
gRomano
  • 31
  • 1
  • 3
2
votes
3 answers

sqlldr running slow after indexes created

let me explain this.... I had ran 1 session of sqlldr while I run indexes into a table for 6 fields... now the indexes are completed but the sqlldr running very slow it loads one file after each 30 minutes... now when I do any alterations to set the…
hi4ppl
  • 141
  • 1
  • 1
  • 6
2
votes
3 answers

Repopulating Oracle tables using data from Excel/CSV file

I'm developing a Java EE application that utilizes Hibernate/JPA. Some of the data I want to use comes from another Business unit's spreadsheet that I need to periodically (re)load into 5 Oracle tables, overwriting any existing data. I'm using a…
jeff
  • 133
  • 1
  • 4
2
votes
0 answers

sqlldr error - Invalid number

I am trying to load the following csv file into a table: TIMESTAMP ; SESSIONID;PROXY_SESSIONID; ACTION;USERNAME ;USERHOST ;OS_USERNAME ;CLIENT_ID ;ACTION_NAME …
oz123
  • 141
  • 1
  • 7
2
votes
1 answer

How does direct path load work when dataguard is enabled?

There's a few posts about direct path and dataguard but I just want to understand exactly how it actually works. How maybe I made an incorrect assumption, but if direct path means it writes to the data files (as per the docs) then doesnt that mean…
Codek
  • 220
  • 3
  • 9
2
votes
1 answer

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, without having to edit my data file by hand. For…
kloppers
  • 21
  • 2
2
votes
1 answer

SQL*Loader-926, ORA-04031 unable to allocate x bytes of shared memory

A customer received this error while importing serveral files. The import routine (VB.NET) is using SQL*Loader (Release 11.2.0.3.0) via Process on each table separately (64 in total) and is called weekly for many years now. Last week following error…
Frederick
  • 23
  • 3
2
votes
0 answers

oracle bulk loader processing columns with newline characters

I'm trying to load a file with description columns which may contain newline characters. The file is Unix format utf16, tab separated and description columns are enclosed in ". The problem is bulk loader assumes the newline is end of record even…
Kevin Tianyu Xu
  • 121
  • 2
1
vote
1 answer

Load file based on line number in sqlldr

I am trying to load header and detail records from a file. The only way I know the difference between the header and the detail records is the line number. The first line is always the header and the other lines are detail records. How can I specify…
Raja
  • 31
  • 1
  • 6
1
2