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

SQL Loader is not inserting data when NULL

I have the following table: Name Null? Type ----------------------------------------- -------- ---------------------------- NAME VARCHAR2(230) TEST …
Madhu Velayudhan
  • 59
  • 1
  • 2
  • 8
0
votes
0 answers

sql loader control file multiple control

I have raw data like this: 2002-3,X52.9418.001 , Abraham, Kennedy James, 111111111, 2125551234,ak123n@aol.com, 123 East 14th Street,, New York, NY, 2002,X52.9418.001 , Richard, Roberts, 111111112, 2125554321,rr345@aol.com, 123 East 14th Street,…
fuermosi777
  • 153
  • 3
  • 9
0
votes
1 answer

Oracle sqlldr : remove delimiter

I have a NPWP column that contains the numbers shown below : npwp 012345678-613.001 001234565-005.000 and npwp's table create table npwp ( no_npwp varchar2(15) ) how to tell loader.ctl in order to remove the mark - and . ? like that ? OPTIONS…
flyingbird013
  • 446
  • 2
  • 12
  • 28
0
votes
1 answer

oracle sqlloader paraller mode

When we are talking about parallel mode with sqlloader what does that actually mean? When i have in my script to execute: Sqlldr control=first.ctl parallel=true direct=true data=first.unl Sqlldr control=second.ctl parallel=true direct=true…
George Georgiou
  • 455
  • 2
  • 14
  • 27
0
votes
0 answers

SQLLDR Database connectivity

We are facing database connectivity issues while running SQL loader utility. When I run the job to call sqlldr from my batch file (on windows), I am able to run my job without any issues. But when the same batch file is run from the scheduler, it is…
U12
  • 83
  • 3
  • 11
0
votes
1 answer

How to load into oracle when timestamp > 12345678900

I have a rather huge file (50mb) where the first field is a unix timestamp. However, I don't want to load the whole file, I need only half of it where timestamp > some_parameterized_timestamp. It would seem sqlldr only allows = and <> conditions in…
Vladiat0r
  • 595
  • 3
  • 6
0
votes
1 answer

how to convert timestamp with timezone to only timestamp while using sql loader

enter code here load data infile '/u01/app/oracle/scripts/Elite_export.csv' discardfile '/u01/app/oracle/scripts/data.dis' into table TBLRADIUSCUSTOMER_TEST fields terminated by "," ( USERNAME…
user3185303
  • 1
  • 2
0
votes
0 answers

in SQL Loader, Can Caret (^) be used as delimiter?

I am using Oracle SQL Loader to load some data into database from a plain text file. Due to lots of special characters are contained in the data so we have to use caret ^ as the delimiter. Just wondering whether SQL loader allows that to happen?…
Jack Gao
  • 9
  • 1
0
votes
2 answers

sql loaded for decimal numbers is going to warning

In my csv file i am having decimal number. I am trying to insert data but the concurrent program is going to warning. In the log Error "Record 1: Rejected - Error on table HR_SAL_DATA_TMP, column CHANGE_PERCENTAGE1. ORA-01722: invalid number". In my…
user3322696
  • 45
  • 1
  • 7
0
votes
0 answers

External table creation in SP

What i am trying is to read data from csv and insert it into external table after insert i have to update my orginal table with the values of extrernal table because couldn't update table using sqlloader for that i have followed as per the link…
jackyesind
  • 3,343
  • 14
  • 47
  • 74
0
votes
1 answer

How to add an update to existing SQL Loader control file?

How to create an external table from my text file and use that to update to real table, rather than creating a (normal) staging table and using SQL*Loader. sample.ctl load data infile 'data.txt' append into table newtable fields terminated by '|'…
Dinesh Kumar
  • 1,173
  • 7
  • 19
  • 30
0
votes
1 answer

How to I load data from CSV by SQLLoader

I am currently facing the problem which the table order in the CSV file is different with the order when i required to load to. I wish to upload the data from csv file in different order with in the database. To best illustrate, i've shown example…
user1090842
  • 25
  • 1
  • 4
0
votes
0 answers

Can we change the return output of sqlldr command

Am using $command = "sqlldr userid=abc/abc_def@defghijk CONTROL= $controlFileName DATA=\"$csvFilePath\" LOG=$logFile1 BAD=$logFile2"; exec($command,$output,$returnValue); And got the output : SQL*Loader: Release 11.2.0.1.0 -…
arul.k
  • 69
  • 1
  • 3
  • 7
0
votes
1 answer

running sqlldr control files in UNIX

I have a question. I have this control files that works fine when I run it from a windows client. However when I run it directly in Linux, it shows load complete but when I look at my oracle data, there is NO DATA and there are even bad records.…
user2008558
  • 341
  • 5
  • 16
0
votes
1 answer

Import file into Oracle by using SQLLoader from VBA

I'd like to be able to import data into Oracle by using SQLLoader (it's MUCH faster than using any other import option) from MS Access VBA. Is there a way of doing that?
lalachka
  • 403
  • 5
  • 16
  • 36
1 2 3
…
67 68