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

How do I import a csv file with data colum in oracle 10g

I have the folowing files arv.csv arv.ctl in my D:\ToBeImportedFiles The contents of arv.csv are 101,2010,12/12/2012 102,2012,15/4/2015 The contents of arv.ctl are LOAD DATA INFILE 'D:\ToBeImportedFiles\arv.csv' REPLACE INTO TABLE…
Arvind Lairenjam
  • 981
  • 1
  • 8
  • 14
0
votes
0 answers

Getting following error in sqlloader

SQL*Loader-500: Unable to open file (C:\sqlloaderpra\tmp.txt) SQL*Loader-553: file not found SQL*Loader-509: System error: The system cannot find the file specified. SQL*Loader-2026: the load was aborted because SQL Loader cannot…
Satheesh K
  • 31
  • 1
  • 4
0
votes
1 answer

What do I need to know about using non-portable datatypes on SQL*Loader?

I read the section in the SQL*Loader reference manual and it's a bit over my head. Our clients are all running x86, so I'm assuming we won't have to worry about byte ordering. However, we do have some customers running on 32-bit and others running…
Jason Baker
  • 192,085
  • 135
  • 376
  • 510
0
votes
1 answer

Load two tables from different databases both oracle using SQL-LOADER

In my job we use Python to make the ETL's. So everything was fine until I had to insert BLOB values. The logic we have is like this. We have a select from the database origin (also Oracle) and we save this data into a .csv file, then we read this…
user1739469
  • 101
  • 1
  • 1
  • 4
0
votes
1 answer

Date format to be loaded using sql loader

I have 03-JUN-2012 16:06:54 format. How do I do this using SQl loader.While using this in control file I used Start date "dd-mmm-yy HH:MM:SS" but it is not working
Janani
  • 653
  • 1
  • 5
  • 5
0
votes
2 answers

Fatal Error message in log file

i have a major error message generated in my log file as i tried loading with sql loader i created a control file named Ad2.ctl with this and the loading command with sqlldr scott/tiger@MYDB CONTROL='Ad2.ctl' LOG='Ad2.log' the content of the…
Abiodun
  • 959
  • 6
  • 17
  • 38
0
votes
2 answers

Error loading data with SQL Loader from command prompt

I am having problems loading a set of csv data with sql loader. i have a control file that contains the data and i have already created the target table in oracle 10g. when i run this following command, C:\Users\lee\sqlloadertest> sqlldr…
Abiodun
  • 959
  • 6
  • 17
  • 38
0
votes
1 answer

Shell script/sql* loader - tabs in place of whitespaces in the output file

I have a task to export the data of a table to flat files.I have written a shell script to do the same. The problem here is after the first column value, i.e., 310, the cursor won't move space by space, it takes a "tab" I think. It jumps certain…
Savitha
  • 405
  • 4
  • 15
  • 25
0
votes
0 answers

Using Excel linked to Oracle for Read/Write access

I am wondering if this is possible. Basically I have a set of 9 users. There is one admin at the top with 2 users under him each with 3 users under them and there is a group of 50 records in an Oracle database table. Each record has a field for…
Ryan
  • 204
  • 3
  • 12
0
votes
1 answer

Problem with Oracle Sql Loader control file

I'm trying to load some data using sql loader. Here is the top of my control/data file: LOAD DATA INFILE * APPEND INTO TABLE economic_indicators FIELDS TERMINATED BY ',' (ASOF_DATE DATE 'DD-MON-YY', VALUE FLOAT EXTERNAL, STATE, SERIES_ID INTEGER…
Marc
  • 3,259
  • 4
  • 30
  • 41
0
votes
1 answer

What would be Replace command behavior(in SQL* Loader) when no data available to load?

I am loading data into one temp table from that table to new table. But I did not apply the check that data is available in the source or not ? So what should be the behavior of Replace option in that case? also explain the behavior.
Learner
  • 1,544
  • 8
  • 29
  • 55
0
votes
1 answer

Writing control File for inserting csv file to Oracle Database

I have a peice of my csv file to show how its formatted. I just wanted to make sure before I went any further that my data would be uploaded correctly into my Oracle database. Im currently using sqlloader to do this. "SERV TAP ID", "ACCT NUMBER",…
Mark Nelson
  • 103
  • 1
  • 3
  • 7
0
votes
1 answer

SQL Loader - Don't require a dat file

I am trying to insert a record into a table. I dont need to access a dat file, because all values are either constants or generated in the control file itself. An example would be - OPTIONS(LOAD=1) LOAD DATA APPEND INTO TABLE table_name (P_ID…
user1427512
  • 1
  • 3
0
votes
3 answers

Get notified when loading of data is done by sqlloader

I have a java code through which I call the bat file. This bat file contains call to sqlldr which loads data from a txt file into a table(in oracle). This is the java code to call the bat file ProcessBuilder pb = new ProcessBuilder(new…
rdp
  • 2,072
  • 4
  • 31
  • 55
0
votes
2 answers

Loading data from multiple text files, with different number of columns to 1 big table

I have 30k+ text files with different number of columns, space delimited, and task is to load data, columns wise, into 1 big oracle table. Details & possible approaches are below: Text File 1- Date Time SiteName CompName ipAdd jkl mno pqr stu…
Chirayu
  • 613
  • 1
  • 6
  • 18
1 2 3
…
67 68