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

Loading a XML file into a xmltype field with sqlLoader

I am trying to load a XML file into a XMLTYPE clob in oracle 11g. So far I came up with this control file: LOAD DATA INFILE 'stocknotify.xml' append INTO TABLE order_input ( xml LOBFILE(CONSTANT 'stocknotify.xml') TERMINATED BY EOF ) This…
ErikL
  • 2,031
  • 6
  • 34
  • 57
5
votes
1 answer

SQL*Loader does not recognize delimiter "¥"

When trying to load an UTF-8 file with ¥ separator, it doesn't separate the fields when it finds the character. We get an ORA-12899 error from the value exceeding the column size, since it tries to put the entire line into the first column. In UTF-8…
luis
  • 53
  • 4
5
votes
3 answers

SQLLoader with a password that contains @-signs

In windows xp, I start sqlloader.exe to load data onto Oracle. This works great, until my password contains an @-sign, that is also used by sqlloader parameters to determine the database to connect to: sqlldr.exe userid/password@database…
Edo de Roo
  • 51
  • 1
  • 2
5
votes
1 answer

Load data from csv file to oracle table from command line

I tried with sql loader.The thing is the table needs to be empty for data loading.Is there any way to do data upload without truncating the table.The CSV data need to be appended in the table.i am using oracle 11g.
jasim
  • 268
  • 1
  • 5
  • 16
5
votes
3 answers

What is more efficient INSERT command or SQL Loader for bulk upload - ORACLE 11g R2

As part of a new process requirement, we will be creating table and which will contain approximately 3000 - 4000 records. We have a copy of these records in plain text on a txt file. Loading these records in the table leaves me with two…
Venus D'souza
  • 135
  • 1
  • 8
5
votes
2 answers

ORA delete / truncate

I'm using SQL loader to load my data into database. Before I insert the data I need to remove existing data in the table: options(skip=1,load=250000,errors=0,ROWS=30000,BINDSIZE=10485760) load data infile 'G:1.csv' "str '^_^'" replace into table…
4est
  • 3,010
  • 6
  • 41
  • 63
5
votes
2 answers

User Interface for creating Oracle SQL Loader control file

Is there a good user interface for authoring Oracle SQL Loader control files? PL/SQL Developer includes a "Text Importer" feature (that reminds one of the Excel import wizard) to import text files into tables, but uses a proprietary format instead…
JoshL
  • 10,737
  • 11
  • 55
  • 61
4
votes
3 answers

SQL*Loader: Dealing with delimiter characters in data

I am loading some data to Oracle via SQLLDR. The source file is "pipe delimited". FIELDS TERMINATED BY '|' But some records contain pipe character in data, and not as separator. So it breaks correct loading of records as it understands indata pipe…
bonsvr
  • 2,262
  • 5
  • 22
  • 33
4
votes
1 answer

Configure Oracle Sqlldr on Windows 7

I'm having a hard time configuring Sqlldr with Windows 7. The Oracle client was previously installed by our support team. There were no registry settings, but Sqlplus, Toad, and Plsql Developer all worked. I copied Sqlldr from another server…
Jeff Young
  • 140
  • 2
  • 10
4
votes
1 answer

Stopping sqlldr

I have a process that load data using sqlldr. But sometimes due to other factors in the system it does not stop in a reasonable amount of time. Is there a way to kill sqlldr safely. Using kill -9.
Abu
  • 303
  • 1
  • 4
  • 12
4
votes
2 answers

how to tell sqlldr to trim trailing and leading whitespace

I'm using sqlldr to load data in which some of the fields have trailing and leading whitespaces. Is there a way to to tell sqlldr to ignore these whitespaces other than by saying field "trim(:field)" ?
Isaac Kleinman
  • 3,994
  • 3
  • 31
  • 35
4
votes
3 answers

Double quotes in the in the data loaded through SQL loader

I have a problem with the data getting loaded to Oracle tables through SQL Loader. The problem is that double quotes is getting enclosed to the value inserted. example: "917681904 " "914481475 " "935848150 " The…
Savitha
  • 405
  • 4
  • 15
  • 25
4
votes
2 answers

Equivalent of SQL loader in MySQL

I have found SQL loader in Oracle is very helpful, fast and efficient. What is the MySQL equivalent of SQL loader?
Suleman Ahmad
  • 2,025
  • 4
  • 28
  • 43
4
votes
1 answer

UTF8 cuts away characters in external tables

I got a strange behaviour with external tables with unicode characters in 18c which didn't occur before in 12.2 As testcase I created a file with a unicode character + ABCD: declare v_file utl_file.file_type; v_bas varchar2(20):='ABCD'; …
Thomas Strub
  • 1,275
  • 7
  • 20
4
votes
3 answers

sqlldr.exe not working for Windows 10

I have recently installed Oracle Database Client (12.1.0.2.0)(winx64) with Custom installation and by selecting only database utilities which will include SQL*Loader among with the other things. But when I am trying to execute sqlldr.exe then I am…
Harshal_Kalavadiya
  • 312
  • 1
  • 5
  • 15
1 2
3
…
67 68