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- data not uploaded to the table. All went to .bad

I tried to upload some records into my table ABC. None of the records went through and they all showed up in the .bad log. I am pretty new to sqlldr. Not quite sure where did I messed up. Let me show you the steps I took. First, I created an empty…
JohnD
  • 353
  • 4
  • 13
  • 26
0
votes
1 answer

Explicit null string in flat files that are imported with SQL*Loader

I am using Oracle's SQL*Loader to import flat files into the database. Is there an explicit NULL string in SQL*Loader, like \N in PostgreSQL, that can be used instead of an empty string? Or is there an option in the control file that can be used to…
Adrian
  • 1,837
  • 1
  • 20
  • 21
0
votes
1 answer

How can I execute custom SQL commands using ORACLE SQLLDR

I have SQL statements as follows: INSERT INTO PERSON(PERSON_ID, YEAR_OF_BIRTH) VALUES (1, 0); UPDATE PERSON SET PERSON_ID=2; How can I execute such type of SQL commands contained successively in a single file? I need to execute this SQL file in the…
suat
  • 4,239
  • 3
  • 28
  • 51
0
votes
1 answer

Can SQL*Loader simulatenously extract data from both an Excel file and an Oracle database?

My team is currently building a data analysis tool for our company that requires us to automatically extract data from both an Excel file stored directly on a client's PC, and an Oracle database on our network where we are pulling an entire table of…
Matthew Neuteboom
  • 127
  • 2
  • 13
0
votes
2 answers

SQLLDR and skip_unusable_indexes

I have a table with a Unique Index that I need to load 800,000 rows into. I altered the index and made it unuseable. I added 'options( rows=4000, bindsize=512000, skip_unusable_indexes=TRUE )' to my control file. I'm still getting errors of the…
Brian Sullivan
0
votes
1 answer

sqlloader date conversion: inconsistent data type

Am trying to load some data to an Oracle database using SQLLoader but I keep getting the errors ORA-00932: inconsistent datatypes: expected DATE got NUMBER or expecting char got date The date comes in the format of e.g. 20130815 and it is to be…
lukik
  • 3,919
  • 6
  • 46
  • 89
0
votes
2 answers

Perl script not running from ksh file

I'm trying to run a bit of perl inside a ksh file and not getting what I would expect from it. Rather than simply getting some sort of error if I was doing something syntactically incorrect, it finishes running and creates lots of .bak files but has…
dlkulp
  • 2,204
  • 5
  • 32
  • 46
0
votes
1 answer

How to use decode in sql-loader?

I use sqlldr to import CSV files and I have some problem with date multiple formats. Dates inside the CSV file are DD/MM/YYYY and if there is no date it is a single dot CSV file DATE_COLUMN;OTHER_COLUMN 01/01/2013;other column content 1 .;other…
kmas
  • 6,401
  • 13
  • 40
  • 62
0
votes
1 answer

Oracle how to load a picture into a blob column using sqlldr

I would like to load employee photos into the table per_images. Per_images used to have a long raw column for the image, but this has changed to a blob. The following sql loader control file used to work with the long raw column: options (bindsize…
Superdooperhero
  • 7,584
  • 19
  • 83
  • 138
0
votes
1 answer

Convert varchar to date in sql loader

I have loaded the date field with dates and type is varchar. How to convert date field(varchar) to date field(date) in oracle express/sql loader while displaying the fields?
RRR
  • 145
  • 1
  • 3
  • 11
0
votes
1 answer

One record spiltted into different lines in sql loader

I was trying create table in oracle express in my local database. While importing the data, i am facing issues where some of the records appear to be in more than one line. I used here /n to start a new line. But i feel that /n is there in between…
RRR
  • 145
  • 1
  • 3
  • 11
0
votes
1 answer

ORACLE SQLLOADER, referencing calculated values

hope you're having a nice day. I'm learning how to use functions on SQL-LOADER and i have a question about it, lets say i have this table table a -------------- code name dept birthdate secret the data.csv file contains this…
E. Diaz
  • 145
  • 2
  • 14
0
votes
1 answer

DBI Oracle and ctl file

i have to use some ctl file with csv file to insert data into an oracle database. Untill now, it has been done by using sqlloader. But, i want to use DBI Oracle CPAN to do the same work and i ask myself how to do that. Here there is an example of a…
Xavier S.
  • 1,147
  • 13
  • 33
0
votes
1 answer

SQL Loader, Trigger saturation?

I have a situation i can't find an explanation for, here it is. (I'll use hypothetical info since the original are really big.) I have a table, let's say: table_a ------------- name last name dept status notes And this table has a trigger on…
E. Diaz
  • 145
  • 2
  • 14
0
votes
1 answer

SQLLoader Strange Behavior

I am using sqlloader to import pdf files to the database as blobs. The control file is as follows LOAD DATA INFILE * INTO TABLE pdf_files APPEND FIELDS TERMINATED BY ',' ( pdfid char(20), pdf_year char(4), pdf_province char(2), …
Raistlin
  • 407
  • 1
  • 8
  • 19
1 2 3
…
67 68