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

Can I execute multiple control files by one command?

I have following 3 control files which I have to execute on my DB server- X.ctl Y.ctl Z.ctl I know the command to execute them one by one which is as follows - sqlldr PP_DBUSER/PP_DBUSER control=X.ctl log=X.log However, can anybody tell me if it…
Bhushan
  • 33
  • 1
  • 3
3
votes
2 answers

SQL Loader : Generate new log file each time

I am using SQL Loader to import data from CSV file to a database table, and it works fine. Each time I run the command sqlldr, the log file is overridden with new infos. Is there a way to add a timestamp or something to keep the archive of those log…
SWEEPY
  • 589
  • 1
  • 6
  • 20
3
votes
1 answer

Load data from multiple lines with condition controller sqlldr

I have a csv file containing data as described below : - Data1|data2|data3.... - Data4|data5|data6.... - Ctr|1|2 - Lst|1|30 - Lst|1|40 - Lst|1|50 - Data7|data8.... - Ctr|2|3 - Lst|2|60 - Lst|2|70 I have a table controle ( data_type…
fati lem
  • 69
  • 2
  • 12
3
votes
1 answer

Commit point in SqlLoader, Used rows not working

I am using SqlLoader to load huge file for this I need to change commit point. I have used rows=1000 but it is not reflecting while executing. I have tried below command to do this : >sqlldr user/pass@db control=myctl.ctl log=mylog.log rows=1000…
CMK
  • 40
  • 2
  • 10
3
votes
1 answer

"No child processes" error in perl

I have a Perl script which invokes the sqlldr and loads data to a table from a flat file. Now, my problem is, even though the sqlldr loads the table fine it is returning exit code as -1(got by using $?), when i tried using $! it says No child…
Vivek
  • 4,452
  • 10
  • 27
  • 45
3
votes
2 answers

SQLLoader 704 Internal error while loading through JAVA

Getting following error on executing sqlldr command. SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] ORA-12154: TNS:could not resolve the connect identifier specified Following is the sqlldr cmd : sqlldr…
Rakesh KR
  • 6,357
  • 5
  • 40
  • 55
3
votes
1 answer

sqlldr does not recognize empty tab delimited columns

I am seeing a strange problem when loading my data with sqlldr. Here is my table schema: CREATE TABLE TEST( "COL1" VARCHAR2 (255 BYTE), "COL2" VARCHAR2 (255 BYTE), "COL3" NUMBER, "COL4" VARCHAR2 (255 BYTE) and here is just one row of…
dmornad
  • 141
  • 1
  • 11
3
votes
1 answer

Load data in Oracle via SQLLDR

I would like to load data in Oracle via the sqlldr, however, it is always loading the data in another format. So does my data from my file look like: 2018-11-27 13 Vienna 1 66.90 1 This is the result after having loaded the…
Bernd
  • 593
  • 2
  • 8
  • 31
3
votes
3 answers

SQLLDR Error: Object does not exist while trying to insert data to a database

I am trying to upload data to a table using sql ldr- sqlldr userid=aa2012/uaxiqdz@ADB control=simple.ctl simple.ctl:- LOAD DATA INFILE '../data/simple.csv' BADFILE '../data/simple.bad' DISCARDFILE '../data/simple.dsc' INTO TABLE…
Radz
  • 543
  • 2
  • 10
  • 22
3
votes
2 answers

Copy tables containing BLOB columns between Oracle Databases

On adhoc basis, we want to copy contents from 4 of our Oracle production tables to QA/UAT environments. This is not a direct copy and we need to copy data based on some input criteria for filtering. Earlier we were using Sybase database hence BCP…
Swapnil Jaju
  • 432
  • 1
  • 6
  • 14
3
votes
1 answer

Oracle SQL sqlldr not importing a latitude/longitude as float

I am trying to import some data with sql*loader but I can't import a latitude/longitude. On the table those columns are FLOAT(126) and on the data file is just text. I tried with FLOAT EXTERNAL on the sqlldr control file but it doesn't work. I got…
Rodrick
  • 595
  • 10
  • 27
3
votes
1 answer

SQL Loader input file more columns than table

I was wondering how do I handle the fact that my input file has 26 columns and the table that the file will be loaded to only has 6 columns, of which some columns values will needed to be hardcoded using the CONSTANT keyword and skipping columns by…
Adil
  • 111
  • 3
  • 11
3
votes
1 answer

How do I run Oracle sqlldr (SQL Loader) on Mac OS?

I have a seemingly simple question. How does one run sqlldr on a Mac OS X? I have researched this topic and have copied the sqlldr executable, using scp, from a remote host running the oracle server, and then installed that into the same…
DAE
  • 123
  • 3
  • 14
3
votes
0 answers

oracle sql loader: value larger than specified precision allowed for this column

I have text delimited file and try to insert to oracle database use sql loader. The content of my file like this. According to mathguy reply, this is the full of my text file content store | datetime | termnmbr | transnmbr | mdesc …
sihombing_j
  • 41
  • 5
3
votes
3 answers

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

Suppose you have a table: CREATE TABLE Customer ( batch_id NUMBER, customer_name VARCHAR2(20), customer_address VARCHAR2(100) ) And suppose you have a control file to populate this table: LOAD DATA INFILE…
Adam Paynter
  • 46,244
  • 33
  • 149
  • 164
1 2 3
…
67 68