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

How can I load large amount of data into oracle database from .csv -file without risking to drop och mismatch data?

I’m in the middle of trying to migrate a large amount of data into a oracle database from existing excel-files. Due to the large amount of rows loaded (10 000 and more) every time, it is not possible to use SQL Developer for this tasks. In every…
anbj
  • 1
  • 1
-1
votes
1 answer

How to load a file (MYFILE.CSV) into Oracle table (BLOBTABLE), using SQL*Loader?

This is just an effort to share a solution that we used in our organisation for the benefit of all. Aim: We have a file MYFILE.CSV. We need to create a table in Oracle database and load this file into that table.
ArtBajji
  • 949
  • 6
  • 14
-1
votes
1 answer

Can't get DATE format in Oracle

I have database in access with a text field '1000306' - it is reporting date. I created table: create table TT ( DT VARCHAR2(20) ); I loaded data by sql loader. How can I get date from it? Should I convert varchar2 to DATE in Oracle? Or should I do…
wakul
  • 1
-1
votes
1 answer

sql loader : Load string greater than 4000 characters using sql loader

I need to load a CSV file into table using sql loader but the lenth of a column is exceeding the Max length of varchar2 data type. Create table statement : CREATE TABLE TEST_PIPE_SEP (FILE_NM VARCHAR2(3000), KEY_COL VARCHAr2(4000), DESCR…
mradul
  • 509
  • 4
  • 12
  • 28
-1
votes
1 answer

Oracle 11g SQL Loader getting 951 error

SQL Loader im gettting 951: Error calling once/load initialization ORA-26002: Table table has index defined upon it. Actually im using parallel=true direct=true options, for parallel execution i removed multiple table indexes and trigger. Still i…
Prasobh Chandran
  • 1
  • 4
-1
votes
1 answer

How to make an INFILE in SQLLDR

Help guys i need to make a dynamic infile. so the common infile is INFILE 'yourcsvfile.csv' LOAD DATA INFILE 'yourcsvfile.csv' append INTO TABLE table_name TRUNCATE FIELDS TERMINATED BY ',' is it possible to make it like this? INFILE (sysdate ,…
ve_1992
  • 19
  • 6
-1
votes
1 answer

SQL*Loader is not working in oracle 12c

Hi I am working with SQL*Loader but its give me an error SQL*Loader-128: unable to begin a session ORA-28040: No matching authentication protocol. My Oracle is 12c and SQL*Loader version is 9.2. What i have to do?
Ashique Sheikh
  • 155
  • 2
  • 4
  • 13
-1
votes
1 answer

Load multiple files content to table using SQL loader

How to insert data from multiple files having different columns into a table in Oracle database using SQL Loader with Single control file. Basically , We have 3 CSV files file 1 having columns a,b,c file 2 having columns d,e,f file 3 having…
harun prasu
  • 95
  • 3
  • 17
-1
votes
1 answer

Can a SQL Loader field be specified by its position relative to the last field?

I have very dirty data in a csv file I need to periodically dump into a table. This csv file contains all the previous records from the previous days (thanks third party vendor!), but I am content to let the unique constraint keep those from…
John O
  • 4,863
  • 8
  • 45
  • 78
-1
votes
1 answer

how to copy the contents from one table to other table using control fiile(.ctl)

i have two data tables A and B in sql database . i want to copy the content of table A to table B i am not able to copy the content of table A if it has dependencies (foreign key relationship)please help me with the control file code (which is…
vamsi
  • 1
-1
votes
2 answers

Not able to set environment in the CSH shell using the .ksh file

I am creating a script to extract the data from one DB and inserting the rows to another DB using the sql loader. I have developed all the scripts and compiled in the .ksh file and need to run the file but before I need to set the environment for…
10hero
  • 15
  • 8
-1
votes
1 answer

Multiple case statements in SQLLDR Control file

I am using a control file to load data into Oracle 11g which is running on windows 7 machine. I have trouble loading the data with the following case statement and I tried different ways, couldn't succeed. Any suggestion? (In the log file the error…
bigZbuzzzinga
  • 17
  • 1
  • 5
-1
votes
1 answer

Can we write a control file such that the FIELDS TERMINATED BY length of characters in text file?

Can we write a control file such that the FIELDS TERMINATED BY length of characters in text file For example if i have a data as listed below 123565966643 984635164666 6164654 2423 can we terminate it by 3 characters such that it would be…
uday krishna kumar raju
  • 46
  • 1
  • 9
-1
votes
1 answer

sqlloader syntax error on command line

I can't figure out where is the syntax error in this case trying to execute the sqlloader by command line. It seems to be ok. Command: sqlldr myuser/mypass@myhost:1521/orcl CONTROL=tbx.ctl LOG=C:\path\to\tbx.log BAD=C:\path\to\tbx.bad skip=0 …
jj-aa
  • 1,019
  • 5
  • 19
  • 39
-1
votes
2 answers

Oracle SQL loader references

Can you guys give me some good references on Oracle SQL loader. I did Google, none of the search I found was useful
Arup Rakshit
  • 116,827
  • 30
  • 260
  • 317
1 2 3
…
67
68