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
3
votes
4 answers

Oracle SQL Loader - How to not display "Commit point reached - logical record count" counts

I'm loading big files via Oracle SQL Loader over vpn from home, and they're taking a lot of time. They were a lot faster to load when I loaded them from work. The files I'm loading are on my work server already. So my thinking is that the slow down…
Superdooperhero
  • 7,584
  • 19
  • 83
  • 138
3
votes
1 answer

Adding clob column to Oracle database using sqlloader

I'm having a file like this delimited by '|' some varchar text | some varchar text | some varchar text | very long text >3500 I need to upload this file using sqlloader . the schema of the table is Name Null?…
Vengadanathan Srinivasan
  • 381
  • 5
  • 12
3
votes
3 answers

import csv file into table using SQL Loader [but large no. of Columns]

I want to import data in the form of csv file into a table.[using Oracle SQL developer].I have such hundred files and each has about 50 columns. From the wiki of SQL*Loader (http://www.orafaq.com/wiki/SQL*Loader_FAQ) load data infile…
prateek
  • 69
  • 1
  • 1
  • 4
2
votes
2 answers

How to really skip the processing of a column?

In order to load data (from a CSV file) into an Oracle database, I use SQL*Loader. In the table that receives these data, there is a varchar2(500) column, called COMMENTS. For some reasons, I want to ignore this information from the CSV file. Thus,…
Romain Linsolas
  • 79,475
  • 49
  • 202
  • 273
2
votes
1 answer

SQL*Loader Hangs forever sometimes

I have SQL*Loader scripts I'm running against an 11g Database. I am using the 11g version of SQL*Loader. I am having an issue where SQL*Loader hangs after the last record is inserted, but before printing the final commit count to the command…
ScrappyDev
  • 2,307
  • 8
  • 40
  • 60
2
votes
3 answers

SQL Loader ctl file - how to skip columns

Let's say in my database 4 columns: Column1, Column2, Column3, Column4 My data file is CSV file (comma delimited, length of column is unknown): xxx,yyy,zzz,000 a,bb,ccccc,ddddddd 1,2,3,4 The CTL will be: LOAD DATA INTO TABLE "TABLE"…
kenny
  • 2,000
  • 6
  • 28
  • 38
2
votes
1 answer

Sql loader conditions

Can I do something like this in SQL LOADER? LOAD DATA INFILE 'table_with_one_million_rows.dat' INTO TABLE TABLE_WITH_ONE_MILLION_ROWS FIELDS TERMINATED BY ',' TRAILING NULLCOLS ( COL1 DECIMAL , COL2 …
Samson
  • 2,801
  • 7
  • 37
  • 55
2
votes
2 answers

Dynamic SQL-Loader control file

I have 20 tables that are temp-tables where we load and validate data constantly and I have a control file for each table. How can I have a unique control file that just changes the table the data is loaded into? Any suggestion? Thanks in…
BRabbit27
  • 6,333
  • 17
  • 90
  • 161
2
votes
1 answer

Oracle bulk loading of user defined types

I am trying to load a large amount of data into my Oracle database, and until now i have been using normal insert statements, but over time the number of rows to insert is increased to over 15mil and it takes to long time. I have been looking at…
aweis
  • 5,350
  • 4
  • 30
  • 46
2
votes
1 answer

Disable BAD/Discard file log on SQL Loader

Is there a way to prevent sqlloader from creating either the BAD file or the DISCARD file or both? I read in a forum that setting the BAD parameter to NUL or NULL does that, but it doesn't seem to work. Something like: sqlldr control=CONTROL.ctl…
Chepech
  • 5,258
  • 4
  • 47
  • 70
2
votes
1 answer

How do I load a column using sqlloader if the CSV column is empty except for the header?

I would like to load a CSV file using sqlloader without having to edit the CSV file each time. When the file is sent to me, the data in the first column is only included in a header above the rest of that data. First code snippet is an example of…
Todd
  • 41
  • 5
2
votes
2 answers

PHP synchronization

I'm unsure of the best solution for this but this is what I've done. I'm using PHP to look into a directory that contains zip files. These zip files contain text files that are to be loaded into an oracle database through SqlLoader (sqlldr). I want…
Jerry Saravia
  • 3,737
  • 3
  • 24
  • 39
2
votes
2 answers

Importing CSV via ORACLE SQL LOADER, line break in double-quote

I'm trying to import CSV via Oracle SQL*LOADER, but I have a problem because some data has line break within the double-quotes. For example "text.csv" John,123,New York Tom,456,Paris Park,789,"Europe London, City" I think that SQL*LOADER uses the…
Sncmlife
  • 31
  • 1
2
votes
0 answers

Sqlldr log shows wrong column name when facing ORA-01722

I have a simple table with three columns. Table name DUMMY20210527 desc DUMMY20210527 PID NUMBER(10) VDATE DATE SID NUMBER(10) Control File LOAD DATA CHARACTERSET JA16SJIS APPEND INTO TABLE "DUMMY20210527" fields…
rajarsic
  • 21
  • 2
2
votes
1 answer

How to trim whitespaces from Japanese characters while loading data into DB through SQL Loader?

I want to load records into Oracle database through SQL Loader. Everything is working fine except for the Japanese characters are not being trimmed and whitespaces are inserted into the DB. Due to this issue, I have to use StringUtils.stripToEmpty()…
Vipul Kumar
  • 67
  • 3
  • 11
1 2 3
…
67 68