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

Loading csv and writing bad records with individual errors

I am loading a csv file into my database using SQL Loader. My requirement is to create an error file combining the error records from .bad file and their individual errors from the log file. Meaning if a record has failed because the date is…
Shubha Parashar
  • 21
  • 4
2
votes
3 answers

External Table - Discard File not generated as expected

I have an external table with the below definition. create table app_doctor ( doc_no number(9), age number(3), eor char(3 char) ) organization external ( type oracle_loader …
RGRam
  • 31
  • 2
2
votes
1 answer

inserting uploaded file values in global table

client uploads text file - contains alphanumeric ID in each line of a text file(single column). What I am doing is, in my controller class I am reading each line from text file and delimit them to comma separated values…
rabbit
  • 45
  • 5
2
votes
2 answers

Problem while using Load when clause?

I need to reject the rows from an external table which starts (first column of every row) with some special characters (eg. ~ \ etc) in a CSV file. For that I have used LOAD WHEN clause in the ACCESS PARAMETERS clause. I have been using the…
Raj
  • 23
  • 2
2
votes
1 answer

SQL Loader - Multiple Files and Grabbing file names

I have a folder with over 400K txt files. With names like deID.RESUL_12433287659.txt_234323456.txt deID.RESUL_34534563649.txt_345353567.txt deID.RESUL_44235345636.txt_537967875.txt deID.RESUL_35234663456.txt_423452545.txt I want to store all the…
dang
  • 2,342
  • 5
  • 44
  • 91
2
votes
0 answers

Oracle 12c - other database sessions long running during SQL-LOADER session running

When a session is loading the table on a different partition using the SQLLDR to spool one flat file , we see other sessions on the same table starts long running and are failing after a long time with the error "ORA-08103: object no longer…
Bhupesh Singal
  • 31
  • 3
2
votes
0 answers

Can Oracle SQL*Loader check for extra delimiters?

From tests done, it seems that loading does not fail if the file contains extra delimiters. Let say I have a control file with 3 columns a,b,c as follows LOAD DATA TRUNCATE INTO TABLE test FIELDS TERMINATED BY "|" trailing nullcols ( a, b, c ) But…
Danjel
  • 71
  • 1
  • 7
2
votes
1 answer

Can I use direct load even if I have SQL functions in the control file?

I have 100 million records to load to a table. I am sqlldr to do so. I have been using the conventional load but is taking long. In the control file I have SQL functions to substring and other data manipulations. My question is, can I use direct…
Jose Ortiz
  • 311
  • 1
  • 3
  • 14
2
votes
1 answer

Inserting a B.C. year value from a flat file to Oracle DB

I am using sqlldr to transfer data from a flat file (.txt) to oracle db. As for dates I am using "to_date(:born, 'DDMMYY')", where born is the column. How can I specify a B.C. year (e.x: 01-01-1000BC) in my flat file so that it can be transfered to…
Bendemann
  • 735
  • 11
  • 31
2
votes
1 answer

SQLLDR - problem with WHEN clauses

I have multiple when clauses in my control file, the data that i am loading in half of them satisfies the when clauses and gets inserted into the desired table. The other half arent (which i expect) but i was expecting the data that doesnt meet the…
user123
  • 21
  • 1
  • 1
  • 2
2
votes
2 answers

Oracle sqlldr - handling null values in input dataset

I am working on moving data from MySQL to Oracle. The MySQL input datasets have been provided via a MySQL data dump. Null values in the MySQL database were written as "\N" (without the quotes) in the output file. I am using sqlldr to get the…
user9074332
  • 2,336
  • 2
  • 23
  • 39
2
votes
1 answer

How to delay a command substitution in a shell script?

I have a bash script that in a nutshell generates a file via other command (works fine) and then later in the script I do a wc command on the file generated. My problem is that i'm using command substitution on the wc command and when I execute the…
Kevin Custer
  • 576
  • 1
  • 5
  • 13
2
votes
1 answer

How to map single file(.csv) column to multiple table columns using sqlldr

I have a file(.csv) contains the columns A1,A2,A3 and Table has the columns T1,T2,T3,T4,T5. I want to map or insert data from A2 column to T2,T3,T4.I am able to insert into T2 and T3 using desc_skip FILLER POSITION(1) in control file(.ctl) but not…
Java Developer
  • 43
  • 1
  • 7
2
votes
1 answer

Auto-Match Fields to Columns SQL LOADER

I'm trying to load some data from csv to Oracle 11g database tables through sqlldr So I was I thinking if there's a way to carry those data matching the columns described on the ctl file with the table columns by the name. Just like an auto-match,…
Mayara Ferreira
  • 23
  • 1
  • 4
2
votes
2 answers

SQLLdr data loading not working through cronjob

I want to load data from multiple files for a project by executing the script via crontab. The script runs well when executed manually but when the script is executed by crontab routine, the sqlldr does not commit the results but moves to the next…
Hammad Ahmed
  • 75
  • 9
1 2 3
…
67 68