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
2
votes
0 answers

Error while loading CSV file to Oracle DB using SQL Loader

I have a CSV file in which their is a multiline data. Important thing to note in that file is that, each record ends with CRLF character, and multi line incomplete record ends with LF. Now if I use below .ctl file for SQL Loader, the records load…
The Coder
  • 3,447
  • 7
  • 46
  • 81
2
votes
1 answer

File name as parameter in SQL LOADER

I have this scenario : In my working directory i have a sh script , ctl file and input file , when i try to launch the shell script with the input parameter (filename.txt): mysh.sh filename.txt i get this error : SQL*Loader-500: Unable to open…
Frank
  • 873
  • 1
  • 7
  • 17
2
votes
2 answers

SQL Loader Issue

Some of the columns that I am trying to load into Oracle via SQL Loader from an XML file are null. For example may have several filled but ocassionally it has some nulls. How can I tell the SQL*Loader that some of the data will be null, or how can…
Overseer10
  • 361
  • 2
  • 9
  • 20
2
votes
2 answers

What is the max value you can set ERRORS to for Oracle SQL*loader?

Straight forward question .. The documentation for Oracle 10 states: Oracle 10g sql*loader documentation (Note, I linked to 10g since it was most convenient, I'll take an answer for Oracle 10 and/or Oracle 11, either way is fine - I suspect it'll be…
Ditto
  • 3,256
  • 1
  • 14
  • 28
2
votes
1 answer

Bulk Load into SAP HANA Database

We were using Oracle DB previously in our Datawarehouse setup. We used SQL*Loader utility for bulk loading which was invoked through Informatica. We are shifting our DB to SAP HANA. We are very new to HANA DB. We were looking for similar command…
Anirudh D
  • 181
  • 3
  • 14
  • 33
2
votes
1 answer

Oracle 12c - SQL Loader Invalid month Error

I'm getting ORA-01843: not a valid month error while loading the data using tab delimited text file with sql loader 11.1.0.6.0 on oracle 12c. control file: options (skip=1) load data truncate into table test_table fields terminated by '\t' TRAILING…
Koushik Ravulapelli
  • 1,140
  • 11
  • 30
2
votes
1 answer

SQL*Loader cannnot load a CSV file that contains multiple lines in one field

I have a CSV file that I'm trying to load into an Oracle table, using SQL*Loader: a, ab, abcdefg b, bc, bcdefghij c, cd, cdefghijk-lmnop orstuv wxyz d, de, defghijk On row "c" the 3rd column has multiple lines, and when we load this row with sqlldr…
user7333846
  • 81
  • 3
  • 10
2
votes
1 answer

Calling os_command.exec from an Oracle stored procedure

I have used os_command.exec to send commands to the Linux shell. I am using Oracle 12c. Here is an example code which works fine: select os_command.exec('/home/smucha/app/smucha/product/12.1.0/dbhome_1/bin/sqlldr userid=system/password…
smucha
  • 55
  • 2
  • 7
2
votes
1 answer

Sqlloader miss the double quote while loading data into database

I have text file and try to load into oracle database and it is able to load into oracle database successfully.Whenever it loads into oracle database it ignore the double quote(") which is within around double quotes. Current sql loader…
user1363308
  • 938
  • 4
  • 14
  • 33
2
votes
3 answers

Difference between sql * plus and sql loader

I am Oracle Data base Bigginner. I am Confusing with this two words sql * plus and sql loader,Any one Tell me the difference between SQL loader and SQL * PLUS?
SanthoshReddy
  • 79
  • 1
  • 2
  • 5
2
votes
2 answers

Bulk data insertion using SQL loader

i am trying to dump 60 million records in to oracle database using sql loader. but it is taking more than 50 mins with options(direct=true,rows = 100000). Do we have any option to make data insertion bit faster. Can we use informatica or java to…
user3396394
  • 35
  • 8
2
votes
2 answers

46 Control Files for SQL Loader

I have to load 46 tables with data using SQL Loader for Oracle. All the data files are CSV. The column order in the CSV matches the column order in the table. I need to create a control file for each table. What is the best way for me to mass…
Raj More
  • 47,048
  • 33
  • 131
  • 198
2
votes
0 answers

SQL Loader get row number for current file when multiple INFILE

How to get the current row number for current file when processing multiple INFILEs in a single SQL Loader CTL. RECNUM does not work here as the INFILEs are effectively treated as a single file. Is there any native SQL Loader way of achieving this? …
Stoof
  • 33
  • 5
2
votes
1 answer

Running SQL*Loader from Java without tnsnames.ora

I'm trying to run SQL*Loader through Java on Unix. I'm using the following command and it works when I run it on the command line (bash): sqlldr userid=user/pass@\"\(DESCRIPTION = \(SDU = xxxx\) \(TDU = xxxx\) \(ADDRESS_LIST = \(ADDRESS = \(PROTOCOL…
Dominik Kunicki
  • 1,037
  • 1
  • 12
  • 35
2
votes
2 answers

How to trim the new line character of column data in ctl file of SQL Loader

My table data has contains new line character it is loading from sql loader ctl file, one column called 'IPADDRESS'is loading with new line character: My ctl file : load data INFILE 'abc.txt' INTO TABLE TABLENAME APPEND FIELDS TERMINATED BY…
Chaya
  • 95
  • 3
  • 12
1 2 3
…
67 68