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
4
votes
1 answer

sqlldr error in Oracle

Currently, I am using sqlldr userid= {user}/{pass}@{SID} to load the file into database, and this comment is in a bash file. The password is generated by a third lib framework. But, I found that sometimes I got the following error, export…
zhianABCD
  • 223
  • 1
  • 4
  • 15
4
votes
1 answer

Skip first 2 rows when loading Table using sql loader

Currently my control file is as : Load data Infile '/.../../emp*.txt' Append into table emp_load When (emp_id <> 'emp_id') Fields terminated by "," optionally enclosed by ' " ' Trailing nullcols (Emp_id "TRIM(:EMP_ID)", EMP_NAME…
user6157109
  • 63
  • 1
  • 1
  • 5
4
votes
3 answers

SQL loader installation

How can I install the SQL Loader, when I have installed the Oracle Data Access Components(ODAC) for windows? I am using oracle DB 11gR2 and oracle ODAC version: 11.2.0.3.
N10ram
  • 81
  • 1
  • 2
  • 7
4
votes
2 answers

Convert date from one format to another using SQL*Loader control file

The data from the infile is in the format MM/DD/YYYY how do I tell the control file to load it into the database as YYYYMM?
Alex Larzelere
  • 1,211
  • 1
  • 11
  • 17
4
votes
2 answers

How can I truncate data to fit into a field using SQL*Loader? (ORA-12899)

Using Oracle SQL*Loader, I am trying to load a column that was a variable length string (lob) in another database into a varchar2(4000) column in Oracle. We have strings much longer than 4000 characters, but everyone has agreed that these strings…
John
  • 41
  • 1
  • 1
  • 3
4
votes
6 answers

SQL*Loader-704 and ORA-12154

sqlldr "xxxx/xxxx@YYYYYXXXX" control=/home/local/INTERNAL/xxxxx/Presc_SQLLDR_File/Presc_SQLLDR.ctl log=/home/local/INTERNAL/xxxxx/Presc_SQLLDR_File/Presc_log.log data=home/achand/Presc_SQLLDR_File/Presc_SQLLDR.ctl Whenever i'm trying to execute…
user4993731
4
votes
1 answer

storing date and time value through SQL LOADER

I am trying to write a control file for a sql loader. The source file to which is in fixed length format. I have date and time present in the source file like say , from position 17 to position 24 for date in CCYYMMDD format and from position 25 to…
Nitin_Sen
  • 331
  • 3
  • 5
  • 10
4
votes
1 answer

Oracle SQL*Loader not honoring skip_index_maintenance parameter

It appears as if Oracle SQL*Loader is not honoring skip_index_maintenance parameter. My control file: unrecoverable load data infile 'filelist2.dat' append into table XML_TABLE xmltype(XMLDATA) ( filename filler char(120), XMLDATA …
Lawrence Tierney
  • 856
  • 1
  • 12
  • 30
4
votes
1 answer

sql loader- files with carriage return, line feed load into oracle with cr/lf

I have data extract from sql server where data in most columns have carriage return and line feeds. I need to load them into oracle with the carriage return and line feed; basically I have to mirror the data form sql server 2012 to oracle 11g. below…
lvss
  • 63
  • 1
  • 1
  • 6
4
votes
2 answers

How do I set sqlldr log file within control file

I have a sqlldr (Oracle SQL Loader) control file (say myControlFile.ctl) and when run it all works OK. However, it writes a log to a file named myControlFile, I would prefer for it to be called myControlFile.log I've read through the docs for sqlldr…
Dave Richardson
  • 4,880
  • 7
  • 32
  • 47
4
votes
2 answers

Running SQL Loader from Java - Not all rows are loaded

I'm trying to run SQL Loader from a Java method but I'm facing a problem. I'm creating a Runtime process to run the SQLLDR command but not all the rows in the data file are being loaded. Instead it's getting stuck at the same number of rows (5184…
user1856152
  • 41
  • 1
  • 3
4
votes
1 answer

Questions on SQL* Loader commit range and display

As per my observation, when we load the data to Oracle tables using SQL* Loader, 64 records are committed at once, by default. Could you please let me know if we can change this default limit of insertion/commit to number other than 64? Also, can we…
Savitha
  • 405
  • 4
  • 15
  • 25
4
votes
2 answers

loading csv file data into oracle database

I am trying to load a csv file in oracle database using sql loader through java program. I have successfully executed it by run command, but i want to load csv file data in database through a java program. My programs…
adityak
  • 192
  • 1
  • 1
  • 12
3
votes
1 answer

SQL Loader line endings

I have a data file that is in Windows format, and would like to load it in to Oracle with sqlldr. Unfortunately the Unix version doesn't intelligently detect with Windows format so I have a load of records with \r in them. Strangely, the Windows…
Greg Reynolds
  • 9,736
  • 13
  • 49
  • 60
3
votes
2 answers

Oracle External Tables: Advanced Flat File Layout

I wish to create an external table in an Oracle database, retrieving its data from a flat file on the server. The format of this file is non-trivial. Each line in this file can be one of several different layouts, depending on the line's prefix (the…
Adam Paynter
  • 46,244
  • 33
  • 149
  • 164
1 2 3
…
67 68