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
1 answer

Removing the “ - “ from input file

The input is -> -747585959 And being loaded as -747585959 I just want it to be loaded as 747585959. Used sql*loader for the data loading process. The “ - “ is the first column and it has “ - “ for all the rows.
Kartik
  • 9
  • 2
-2
votes
1 answer

How to load sample.xlsx in oracle data base using sql loader

I am trying to load my data which is in excel format but i am not able to do that.could you please help me on this.
chandan kr
  • 1
-2
votes
2 answers

SQL Loader quit working on new computer

I was successfully loading csv files using SQL*Loader. After getting a new computer, the files no longer load. I'm using the same batch and control files. When I run the batch file, a command prompt screen flashes on the screen, but I don't get any…
FGT
  • 11
  • 1
-2
votes
1 answer

How to load data to 1 table with 3 columns from a CSV file that has 5 columns?

My CSV data: 10,ABC,10000,101,DEPARTMENT 11,XYZ,,,DEPT2 I wanted to insert it into the table with 3 columns: EMPID,EMPNAME,DEPARTMENT
arunkumarmsk
  • 19
  • 2
-2
votes
1 answer

How to improve SQLLDR performance?

I am trying to upload a csv file into Oracle server through sqlldr for my batch file automation. It takes too much time to upload the file into Oracle server with sqlldr. Through batch it uploads 2100 rows in a minute. When I try to import data…
Ashique Sheikh
  • 155
  • 2
  • 4
  • 13
1 2 3
…
67
68