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

Oracle SQLLOADER - How to Load Data in format of dd-mon-rr

I have text comma separated file in format below. "RAZY","","","","","","","","N","Y","27-JUL-14","1","98727076437","27-JUL-14" "TEST","","","","","","","","N","Y","27-JUN-14","1","98727076437","27-JUN-79" I am trying to load this using a SQL…
crazywolf
  • 3
  • 1
0
votes
2 answers

Need regular expression for restricting special characters

I need to replace the following special characters with empty string. ™,®,',(TM),(R),é,�,’,–,†I was using trim(regexp_replace(:DESC, '(*[\\™®])', ' ')) But it was failing. Tool is Sql Loader. Thanks in Advance
Kokirala Sudheer
  • 429
  • 2
  • 8
  • 20
0
votes
1 answer

SQL Loader Error - SQL*Loader-503: Error appending extension to file ()

I am trying to load a bunch of Java files into a staging table using SQL Loader. I keep getting the subject line error and I'm not sure why. My executable file that I am trying to run looks like this. for i in `find
Andrew Hummel
  • 400
  • 2
  • 5
  • 22
0
votes
1 answer

Load File to Oracle TIMESTAMP(6) Format

I'm trying to load FLATFILE data to Oracle via Sqlloader, but I'm having trouble with a timestamp(6) field. I have timestamp values in the below format: Wed May 08 00:00:00 UTC 2013 I need sqlloader code to load this time format in oracle. My…
Elavarasan
  • 301
  • 1
  • 5
  • 14
0
votes
0 answers

oracle sql loader skipping columns in .csv file

*Hi All, I would greatly appreciate if someone could help me with the SQL loader upload Issue : I have a .csv file to be uploaded into a table. The file has 18 columns and I need to skip the first 12 columns. I tried all methods using FILLER on the…
user3130236
  • 71
  • 1
  • 6
0
votes
2 answers

Error in SQL loader, number not valid ORA-01722

I want to charge a sql loader in field named ID_CARGA, this one is a number(18) in database. I have in loader this line: ID_CARGA(1:18) ":ID_CARGA", But when i try to load this data: 000000000000000000 Says that ORA-01722, How can i load this…
vem
  • 93
  • 1
  • 7
0
votes
1 answer

Why did SQL*Loader load 808594481 when using the INTEGER data-type?

I was loading data using SQL*Loader and when making the control file I used the table definition and accidentally left the INTEGER data type on the "version" line. And in the "version" field (data type integer) it inserted the value 808594481. I'm…
Robert Clayton
  • 3
  • 3
0
votes
1 answer

Headache loading timestamp with Oracle Sqlldr

Hi All i'm having an issue loading a file with timestamp values with sqlldr, can anyone please help with an idea? This is what a line of my file to load with the timestamp looks like : ..... 2014-09-02-00.00.00. And my ctrl file : ... ... Field …
stk
  • 1
  • 1
  • 1
0
votes
0 answers

Oracle SQL Loader using batch and command file in windows 7

I am trying to automate the entire data loading from a flat file to a table in database in Windows 7 environment. So, I created a windows batch file(Data_Load.bat) in C:/Data_Load folder. This takes the input as to which data has to be loaded. Once…
Cool_Oracle
  • 311
  • 1
  • 4
  • 15
0
votes
3 answers

How to a csv file in oracle using sql loader in java

I want to load data from a csv file to oracle database. Here is my code- void importData(Connection conn) { Statement stmt; String query; String filename = "C:/CSVData/Student.csv"; try { stmt = conn.createStatement( …
Subho
  • 921
  • 5
  • 25
  • 48
0
votes
1 answer

DATETIME/INTERVAL datatype conversion error

i'm trying to load data in oracle but get subject mentioned error in my log the format of date in my data is like (2014.08.08 04:27:24) without brackets and the my DDL where I create table is simple CREATE TABLE tablename ("registerdate"…
hi4ppl
  • 595
  • 1
  • 6
  • 21
0
votes
0 answers

external table bad files

I am using external table for ETL. The access driver creates a bad file which contains records which were bad in some way like data type mismatch. However, constraint violations like unique constraint violation are not written to Bad file by access…
user2599052
  • 1,056
  • 3
  • 12
  • 27
0
votes
2 answers

Error ORA-01841: when passing date of birth in a file

I am passing "19851003" as date of birth in a file but i am getting the following error in the log file. ORA-01841: (full) year must be between -4713 and +9999, and not be 0 Any idea why is the error coming as i am passing it as a string only Error…
user3809240
  • 93
  • 1
  • 3
  • 18
0
votes
0 answers

SQLLoader optional lines in a csv-file

there are several csv-files which I have to put in a database via sqlloader. The files look like this: nr, value,description 839, 73, mydescription 842, 12, mydescription But some lines in these files are optional and for these specific lines (839,…
Michael
  • 1
  • 1
0
votes
1 answer

load data using sql loader based on string values

I have a dataset which is like 1,2,3,4,5,{1,2,3,4},{1,2,3,4} I want to load the data as columnA ColumnB ColumnC ColumnD ColumnE ColumnF COlumnG 1 2 3 4 5 {1,2,3,4} {1,2,3,4} I have used columnF and ColumnG as…
ThePatBan
  • 107
  • 2
  • 15
1 2 3
…
67 68