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

loading data in table using SQL Loader

I'm loading data into my table through SQL Loader data loading is successful but i''m getting garbage(repetitive) value in a particular column for all rows After inserting : column TERM_AGREEMENT is getting value '806158336' for every record My csv…
arjun gaur
  • 518
  • 1
  • 9
  • 25
3
votes
1 answer

External table limitations

Now i am working on external tables... While i do like its flexibility. I would like to know these things about external table - Like in SQL Loader we can append data to the table . Can we do that in External table ? In external table , we cannot…
divya.trehan573
  • 454
  • 1
  • 12
  • 28
3
votes
1 answer

Keyword error with SQL*Loader and generated control file

I am a creating control file dynamically when my shell script runs, with: echo 'LOAD DATA' > $CTLDIR/test.ctl echo 'TRUNCATE' >> $CTLDIR/test.ctl echo 'INTO TABLE TEMP' …
user3195273
  • 193
  • 1
  • 5
  • 13
3
votes
1 answer

Euro '€' symbol not inserted correctly during Oracle SQL LOAD

I'm loading a csv file using sqlldr. the file contains the symbol "€" which is inserted into a VARCHAR2 column. After the load, the database displays '¿' instead of the euro symbol. I have specified the characterset in the control file during the…
Slimane Agouram
  • 365
  • 1
  • 5
  • 17
3
votes
2 answers

SQL*Loader-522: lfiopn failed for file

I am getting below error in my script which is running a SQLLDR : SQL*Loader-522: lfiopn failed for file (/home/abc/test_loader/load/badfiles/TBLLOAD20150520.bad) As far my knowledge this is the error related to permission,but i am wondering in…
sabya
  • 109
  • 2
  • 4
  • 20
3
votes
3 answers

Loading large amounts of data to an Oracle SQL Database

I was wondering if anyone had any experience with what I am about to embark on. I have several csv files which are all around a GB or so in size and I need to load them into a an oracle database. While most of my work after loading will be…
James
  • 572
  • 3
  • 9
  • 17
3
votes
1 answer

reset sequence value to 1

I have test.csv,test1.csv,test2.csv...etc files. These files i am loading into custom table test through sql loader. in table test i have columns named seq_no,process_id apart from columns coimng from flat file mentioned above. i had created two…
user3195273
  • 193
  • 1
  • 5
  • 13
3
votes
1 answer

Date format for SQL*Loader

I am trying to import a file of records into a table and am getting Rejected - Error on table FUNDPRICE_TEST, column FUNDDATE. ORA-01843: not a valid month I did some research and read that Oracle by default expects dates formatted yyyymmdd.…
Clint L
  • 1,093
  • 5
  • 12
  • 29
3
votes
2 answers

Java program that calls external program behaving asynchronously?

All, I originally had a shell script that called SQLLoader (Oracles data upload tool). The problem was that SQLLoader takes a plain text password as input so I decided to build a Java application to call SQLLoader internally passing a decrypted…
tomaytotomato
  • 3,788
  • 16
  • 64
  • 119
3
votes
1 answer

sql loader truncate always the first column

I used oracle 10g and I have this file.ctl OPTIONS (SKIP=1) LOAD DATA INFILE '/home/gxs/segmentation/sqlloader/datos.csv' APPEND INTO TABLE test (id "s_test.nextval", name char(10) TERMINATED BY ',' , tel char(20) TERMINATED BY ',' , apellido…
user2456216
  • 143
  • 3
  • 10
3
votes
2 answers

SQL loader position

New to SQL loader and am a bit confused about the POSITION. Let's use the following sample data as reference: Munising 49862 MI Shingleton49884 MI Seney 49883 MI And here is the load statement: LOAD DATA INFILE 'zipcodes.dat' REPLACE…
JohnD
  • 353
  • 4
  • 13
  • 26
3
votes
1 answer

How to use to_number and nullif in sql-loader?

I've had a similar problem with dates (combination of to_date and nullif) here : How to use decode in sql-loader? And it was solved nicely. My problem is that a numeric field in my CSV file can have these formats : 999,999,999.99 or just a dot '.'…
kmas
  • 6,401
  • 13
  • 40
  • 62
3
votes
4 answers

Accessing data filename from within SQL*Loader control file

How do I access the input data file name from within SQL*Loader control file so that I can insert it into the table along with data from the input file? Let's say for example I have the following control file: LOAD DATA APPEND INTO TABLE…
Lukman
  • 18,462
  • 6
  • 56
  • 66
3
votes
1 answer

sqlldr not found when using SQL*Loader in a shell script

I would like to create shell script, AUTOLOAD that will, when ran, execute SQL*Loader with a set of instructions. All this is in my Linux environment. SQL*loader will then import data to SQL developer #!/bin/sh # echo -------- SQL loader -------- #…
Angelina
  • 2,175
  • 10
  • 42
  • 82
3
votes
3 answers

Choice of technology for loading large CSV files to Oracle tables

I have come across a problem and am not sure which would be the best suitable technology to implement it. Would be obliged if you guys can suggest me some based on your experience. I want to load data from 10-15 CSV files each of them being fairly…
Vishal
  • 1,169
  • 2
  • 12
  • 20
1 2 3
…
67 68