Stack Overflow
Stack Overflow

Questions tagged [sql-loader]

SQL*Loader is a high-speed data loading utility that loads data from external files into tables in an Oracle database.

SQL*Loader is a high-speed data loading utility that loads data from external files into tables in an Oracle database. SQL*Loader accepts input data in a variety of formats, can perform filtering, and can load data into multiple Oracle database tables during the same load session.

Source: http://www.oracle.com/technetwork/database/enterprise-edition/index-093639.html

1010 questions
7
votes
2 answers

Can you see load progress when running sqlldr with DIRECT = TRUE?

I am loading a large file (~22 GB) to Oracle with sqlldr, using the direct = TRUE option (otherwise it would probably take months). So it's been sitting there for several hours, loading as best I can tell, but I have no way of knowing how much…
James King
  • 6,229
  • 3
  • 25
  • 40
7
votes
1 answer

How to import "loader" format data using SQLDeveloper?

How do I import data in "loader" format using SQL Developer? SQLDeveloper can export data in "loader" format, so I would like to re-import it. Note: I'm not able to login to the server on which the Oracle DB is running, and I don't have sysdba…
leo
  • 3,528
  • 3
  • 20
  • 19
7
votes
4 answers

External Tables vs SQLLoader

So, I often have to load data into holding tables to run some data validation checks and then return the results. Normally, I create the holding table, then a sqlldr control file and load the data into the table, then I run my queries. Is there any…
moleboy
  • 884
  • 1
  • 10
  • 17
7
votes
1 answer

Setting the Date Format in the SQL*Loader Control File

I have csv file that has "17 September, 2009 11:06:06 AM" as COMPLETED_ON variable I am using sql loader to load data to oracle with folowing: LOAD DATA INFILE 'c:/load/file_name.csv' APPEND INTO TABLE tbl_name FIELDS TERMINATED BY ',' OPTIONALLY…
Angelina
  • 2,175
  • 10
  • 42
  • 82
6
votes
1 answer

Update a column in table using SQL*Loader

I have written an SQL script having the below query. The query works fine. update partner set is_seller_buyer=1 where id in (select id from partner where names in ( 'A','B','C','D','E',... -- Around 100 names. )); But now instead of writing…
vikiiii
  • 9,246
  • 9
  • 49
  • 68
6
votes
5 answers

Loading Unicode Characters with Oracle SQL Loader (sqlldr) results in question marks

I'm trying to load localized strings from a unicode (UTF8-encoded) csv using SQL Loader into an oracle database. I've tried all sort of combinations but nothing seems to give me the result I'm looking for which is to have special greek characters…
philrabin
  • 809
  • 2
  • 11
  • 21
6
votes
2 answers

SQL*Loader stuck after loading 4.2 billion records

We are stuck with a problem in sql loader. We are trying to load a data file with around 4.6 billion rows (nearly 340 GB) into 2 oracle tables on the basis of some when condition using Sql Loader. But after loading 4.2 billion records the SQL loader…
SRD
  • 61
  • 1
  • 3
6
votes
2 answers

SQL Loader script help with adding SYSDATE, USER

I'm trying to load data from a file and I want to set CREATED_DATE and UPDATED_DATE to SYSDATE and CREATE_BY and UPDATED_BY to USER Here the table that I'm working with: CREATE TABLE CATALOG (CNO NUMBER, CTITLE VARCHAR2(25), CREATED_BY VARCHAR2(10)…
relyt
  • 679
  • 6
  • 14
  • 26
6
votes
2 answers

Can variables be passed to a SQL*Loader control file via sqlldr command?

Below is my Control file example : OPTIONS (skip=1,errors=1000,direct=true,rows=10000) load data append into table TABLE_NAME fields terminated by ',' OPTIONALLY ENCLOSED BY '"' trailing nullcols( DATE_ID …
arul.k
  • 69
  • 1
  • 3
  • 7
6
votes
1 answer

SQL Loader with utf8

I am getting following error while loading Japanese data using SQL*Loader. My Database is UTF8 (NLS parameters) and my OS supports UTF8. Record 5: Rejected - Error on table ACTIVITY_FACT, column METADATA. ORA-12899: value too large for column…
AbhiDwi
  • 93
  • 1
  • 3
  • 9
5
votes
4 answers

How do you convert from scientific notation in Oracle SQL?

We are trying to load a file created by FastExport into an oracle database. However the Float column is being exported like this: 1.47654345670000000000 E010. How do you configure SQL*Loader to import it like that. Expecting Control Script to…
ScrappyDev
  • 2,307
  • 8
  • 40
  • 60
5
votes
1 answer

Oracle 11gR2 loading multiple files: sqlldr or external tables?

I have 471 files totaling about 100GB. The files are "\t" separate, with transaction data in the following format: char(10) not null, char(8) not null, char(1) not null, char(4) not null, number not null, char(1) not null, char(1) not null, char(1)…
anti_ml
  • 481
  • 4
  • 15
5
votes
1 answer

Oracle SQL*loader running in direct mode is much slower than conventional path load

In the past few days I've playing around with Oracle's SQL*Loader in attempt to bulk load data into Oracle. After trying out different combination of options I was surprised to found the conventional path load runs much quicker than direct path…
Stanley
  • 115
  • 3
  • 7
5
votes
2 answers

Difference Between Insert and Append statement in SQL Loader?

Can any one tell me the Difference Between Insert and Append statement in SQL Loader?consider the below example : Here is my control file load_1.ctl load data infile 'load_1.dat' "str '\r\n'" insert*/+append/* into table…
Rajesh Kumar G
  • 1,424
  • 5
  • 18
  • 30
5
votes
3 answers

Oracle SQL Loader split data into different tables

I have a Data file that looks like this: 1 2 3 4 5 6 FirstName1 | LastName1 | 4224423 | Address1 | PhoneNumber1 | 1/1/1980 FirstName2 | LastName2 | 4008933 | Address1 | PhoneNumber1 |…
Chepech
  • 5,258
  • 4
  • 47
  • 70
1
2
3
…
67 68