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

set up proper date format

in csv file I have column, where are date's with diffrent format as below: 02/03/2014 00:10 1/02/2014 7:25:00 7/03/2013 8:30:00 PM How to set up proper date into CTL file in SQL-LOADER? column1 "to_date(:column1, 'DD/MM/YYYY HH24:MI:SS')"
user3090396
  • 3
  • 1
0
votes
2 answers

Loading currency symbols using SQL*Loader

I am trying to load a csv file with currency symbols, using SQL*Loader. The symbol '£' gets replaced by '#' and symbol '€' gets replaced by NULL. Not sure if I should tweak some settings in my control file? Here are the values from…
KLeonine
  • 167
  • 2
  • 10
0
votes
1 answer

why table is not created using SQLLDR in shell script?

Below is the script I use:a #!/usr/bin/ksh echo "create table temp_a" > emptab.sql echo "(" >> emptab.sql echo "subscriber_no int" >> emptab.sql echo "); commit" >> emptab.sql sqlplus -s user/passC@db << eof …
Peter Nijem
  • 3,625
  • 2
  • 12
  • 7
0
votes
1 answer

How to one data file upload into multiple table by sql loader in oracle 10g example

Create table emp (id varchar2(22), name varchar2(85),hire_date date,department_id varchar2(3)); create table emp_epfo as select id emp_id,name lname,hire_date,department_id dept_id from emp where 1=2; Control file LOAD DATA INFILE …
user2703444
  • 301
  • 1
  • 3
  • 4
0
votes
1 answer

How can I use a variable in batch script at sqlldr?

I have a variable in batch script and I want to use this variable at sqlloader code for infile. How can I do?
mbakay
  • 21
  • 5
0
votes
1 answer

How to insert name of file and modified time using batch/shell script and sql loader

I have a requirement to insert bulk data into an Oracle database from a CSV file. Now table columns specs match those of the CSV file's header with the exception of three additional fields in database: A Primary Key field (for which a simple…
WrijuB
  • 141
  • 1
  • 3
  • 14
0
votes
1 answer

Bad characters and sql*loader

how to find out mal characters(unsupported eg. Ω ) when inserting using sqlloader? or list the mal characters to avoid junk data?
sekar
0
votes
1 answer

How can I upload a specific field massivel in Oracle

I have a table as following with more fields but not put all. Table: id_service id_date_suscription id_date_unsuscription .. I have a ctl with which insert data id_date_suscription filling the field and everyone else, but leaving nul…
user2456216
  • 143
  • 3
  • 10
0
votes
1 answer

skip records in multi table insert while using Oracle Loader

I have a pipe delimited file having around 100 Million records and each records having 62 fields, I want to load this data into two Database tables having 50 and 45 columns... I just want to ask that how can i skip columns of file while writing…
Naveed Ahmad
  • 1
0
votes
1 answer

php not running sqlldr

I have a problem here whereby when i run sqlldr command using PHP, it does not seem to work. but when i run the exact same command in the linux command line, it works perfectly. It does not give me any error when running in PHP. The following is…
Steven Tang Ti Khoon
  • 479
  • 2
  • 6
  • 17
0
votes
1 answer

Avoid duplicate rows with SQL Loader

I'm loading a bunch of data from a file to a table in a database with SQL*Loader. My control file is this: OPTIONS (DIRECT=FALSE) LOAD DATA INFILE * BADFILE * APPEND …
eloweyn
  • 123
  • 1
  • 4
  • 17
0
votes
1 answer

Loading a CSV file in a table using sqlloader

I have CSV file having two columns id_a and id_b, but I need to insert 4 more columns; ie. emp_sal_a, emp_sal_b, emp_dept_a, emp_dept_b using sqlldr. So my current control file looks like: load data infile '/home/.../employee.txt' into table…
user2875329
  • 1
  • 2
0
votes
1 answer

Insert actual date time in a row with SQL*loader

I have a Oracle SQL*Loader. I need to insert lots of records in a Oracle Database. Here is my .ctl file: OPTIONS (DIRECT=TRUE) UNRECOVERABLE LOAD DATA …
eloweyn
  • 123
  • 1
  • 4
  • 17
0
votes
2 answers

Error using SQL loader

I am trying to import data from .dat file to a table in oracle database, using SQL loader. control file: LOAD DATA infile 'E:\labs\labs\lab_18_06.dat' INTO TABLE INVENTORY.PRODUCT_ON_HAND APPEND FIELDS TERMINATED BY…
spin_eight
  • 3,925
  • 10
  • 39
  • 61
0
votes
1 answer

Oracle SQL Loader control file delimiter

I want to import a table of customer information to my database. The structure of the data file (plain text) is briefly shown below. "Cust_ID Cust_Name Level" "0001 Eric Cartman 05" "0002 Kyle Broflovski 02" Each line enclosed by " is a…
goldfrapp04
  • 2,326
  • 7
  • 34
  • 46
1 2 3
…
67 68