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

Processing data by stored procedure after uploading data by sql*loader

I wrote a .sh script which should upload data from file by sql*loader and then run stored procedure which should proceed uploaded data. #!/bin/bash ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1 export…
May12
  • 2,420
  • 12
  • 63
  • 99
0
votes
3 answers

How to handle line breaks in data for importing with SQL Loader

I am a front-end developer writing a C# application to export data from an oracle stored procedure into a text file for later importing into a different oracle database. The data will be loaded with SQL Loader (sqlldr) and I am trying to understand…
DrFloyd5
  • 13,555
  • 3
  • 25
  • 34
0
votes
1 answer

Twin problems with Oracle jdbc and sqllr

I am facing two issues which I believe may be related. I am trying to execute a JDBC select against oracle (10g) database and result set shows the date column as a timestamp ResultSetMetaData rsMetaData = null; rsMetaData =…
ajay
  • 651
  • 2
  • 8
  • 16
0
votes
1 answer

Wait for end of sql loader work before execute sql script in unix bash file

Tomorrow will be a work day for me =(. Colls, i need that sql script wait an end of sql*loader work in my -bash script. Is it right code below?: #!/bin/bash echo -------- uploader.sh v 0.1 -------- # @echo; export…
May12
  • 2,420
  • 12
  • 63
  • 99
0
votes
1 answer

.bat to .sh converting for SQL*Loader Start on UNIX PC

I have a simple .bat file @echo; set nls_lang=russian_cis.ru8pc866 @echo off SET NLS_NUMERIC_CHARACTERS=. ' sqlldr.exe userid=PRB/0611@TSESTDB control=control_file.ctl LOG=fdb_log.log errors=100 cmd and i need to convert to .sh file for…
May12
  • 2,420
  • 12
  • 63
  • 99
-1
votes
2 answers

Crontab issue with perl script

system("$sqlldr $oracleLogon control=$ctlFile log=$logFile data=$dateFile"); Above is the last line of my perl script. When I run script which containing this line manually (from cli) it works. But when I put it to crontab, getting fail. …
tsoomo
  • 95
  • 7
-1
votes
2 answers

sql * loader file not axtracting (DATE DATATYPE)

LOAD DATA INFILE "C:\\Users\\lenovo T480\\Desktop\\all_2012.csv" DISCARDFILE "C:\\Users\\lenovo T480\\Desktop\\BANKING_DATA_DISCARDED.txt" TRUNCATE INTO TABLE BANKDTLS FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY…
Jnanendra Y
  • 5
  • 3
-1
votes
1 answer

how to use oracle sqlldr to load excel csv file without comma at end

I have csv file as: 1,2,3 control file: fields terminated by ',' however, when I load the data, I got ORA-01722 invalid number. if I add , at the end of the file like 1,2,3, then all three columns will be loaded, is there any option to load all…
xiaoyunwu
  • 69
  • 6
-1
votes
1 answer

How to format oracle connection string and output query to file

I am trying to connect to a oracle database, query it, and send results to a txt file. When I run my statement, this shows in the .txt file: In reality, it should be values from my sql script. Here is the string i am…
mali_the
  • 25
  • 1
  • 8
-1
votes
1 answer

run 19c sqlldr throws - error while loading shared libraries: libnnz19.so

I have downloaded instantclient-tools-linux.x64-19.12.0.0.0dbru.zip on oracle enterprise linux 7 from oracle site and trying to run sqlldr cmd. Initially i got this error. /scratch/guid/sqlldr/instantclient_19_12/sqlldr: error while loading shared…
Saro
  • 11
  • 5
-1
votes
1 answer

sql loader is not loading the table with the error SQL*Loader-601:

there is a daily job that runs 4 times a day. I could see that weekly twice the last 4th job is failing and by log i could see that it shows as SQL*Loader-601: For INSERT option, table must be empty. For each run the job creates a temporary table…
User071295
  • 1
  • 3
-1
votes
1 answer

Inconsistent date format in data being loaded with sql loader

I am trying to load data into some tables using sql loader. One of the columns, EXPIRATION_DATE, contains a date where most of the entries are in the form of mm/dd/yyyy, but there are a few that are in the form of dd-mon-yy. My current .ctl file…
cdm
  • 1
  • 1
-1
votes
1 answer

How to load 10k above charecter to single oracle coulmmn using sql loader

I am spooling data from cassandra as file. Column is Id | text_file --------------- 1 JSON string (13000 characters string) i have to load this data to oracle table. what should be my oracle table structure and ctl file format.
Saumya Ranjan
  • 75
  • 1
  • 3
  • 11
-1
votes
1 answer

How to load a csv file into a database when the filename for the CSV changes everyday

Trying to load a .csv into a database using SQL loader but The filename is changing every day but will always start with health_safety. Here is the control file, it loads the data but I need to put in a specific file name, so if the filename…
Trent
  • 1
  • 1
-1
votes
1 answer

Insert data into database using sqlldr in coldfusion

I have a CSV file that I got from a website. I need to upload that same CSV file into my database using SQLLDR in ColdFusion. For some reason I'm not able to insert the data into database. Below is my code. Using this code I was not able to insert…
user3440782
  • 144
  • 1
  • 14
1 2 3
…
67 68