Questions tagged [sql-loader]

SQL*Loader is a bulk loader for Oracle

Filter by
Sorted by
Tagged with
-1 votes
1 answer
20 views

Expecting "," or ")", found "nvarchar2"

Here is my SQL*Loader: Release 11.2.0.2.0 - Production on Fri Nov 10 00:39:56 2023 OS=UBUNTU 20 I am trying to load data from csv file with the help of following code: OPTIONS (SKIP=1) LOAD DATA ...
Java_Beginner's user avatar
0 votes
0 answers
36 views

Problem to start sqlldr with parfile=parfile.par

If have installed Oracle Client 21.11 under Ubuntu. Sqlplus is working fine so far. Only when I try to use sqlldr in combination with parfile it is not working. when I call sqlldr user.../pw...@...
user avatar
1 vote
2 answers
1k views

How can I use pg_dump to export a single table to CSV that can then be imported by Oracle SQL Loader?

Thanks in advance for any help on this. Problem Summary: I'm looking for the most efficient way possible to export a single table from Postgres/Greenplum for a large number of records (100M+) so that ...
zigmoo's user avatar
  • 11
0 votes
2 answers
76 views

Efficient approach to Query DB with data in text file [closed]

I've got an oracle DB set up and want to Query it after I receive data in a text file. Number of product-names present in text file are around a million. After Searching a lot I've found 2 ways of ...
Anubhav's user avatar
  • 21
0 votes
1 answer
169 views

SQL*Loader and DC firewall timeout

We are loading a huge dataset using SQLLDR and there are index creation that lasts for a couple hours or even more. Firewall drops this connection as there is no data transfer during index creation ...
Mikhail Aksenov's user avatar
0 votes
1 answer
1k views

When is the best time to use RMAN vs when to use Data Pump? [duplicate]

And also... if I backup a database with RMAN, is it not possible to use impdp to restore small parts of that database?
Phillip's user avatar
  • 11
0 votes
1 answer
673 views

sqlldr syntax error [closed]

oracle@tdc2mdb07> cat rsm.ctl ************************************************** LOAD DATA infile '/tmp/20181012_bkp.txt' REPLACE INTO TABLE ASSET_ODS.ROADSIDE_MESSAGE FIELDS TERMINATED BY '|' ...
user avatar
1 vote
0 answers
1k views

SQL Loader intermittently throws "ORA-12516: TNS:listener could not find available handler with matching protocol stack"

I am running a weekly batch job which is loading data from txt/csv files to database using SQL Loader. But SQL Loader intermittently throws below error: SQL*Loader-704: Internal error: ulconnect: ...
Abhinav Soni's user avatar
0 votes
1 answer
1k views

Loading Oracle ctl export file into postgresql

I have a number of tables exported from an oracle database in the form of Ctl files with that data included within the file. Im looking for a way to import these into postgresql but the the ...
Stevetech's user avatar
  • 119
1 vote
0 answers
388 views

Modification of the sql loader control file

I am working on a script which uses Oracle SQL *Loader to load data into a table. However, anywhere I search about the control file of an sql loader I am seeing only statements like: "load data into ...
private ryan's user avatar
2 votes
1 answer
1k views

SQL*Loader-926, ORA-04031 unable to allocate x bytes of shared memory

A customer received this error while importing serveral files. The import routine (VB.NET) is using SQL*Loader (Release 11.2.0.3.0) via Process on each table separately (64 in total) and is called ...
Frederick's user avatar
2 votes
1 answer
8k views

NLS_NUMERIC_CHARACTERS in SQL loader control file

I am using a Control File to import data from a CSV file into a table, using sqlldr to import the data, where a large number of fields are numeric values with integer and decimal part separated by ...
gRomano's user avatar
  • 21
2 votes
0 answers
501 views

oracle bulk loader processing columns with newline characters

I'm trying to load a file with description columns which may contain newline characters. The file is Unix format utf16, tab separated and description columns are enclosed in ". The problem is bulk ...
Kevin Tianyu Xu's user avatar
1 vote
1 answer
3k views

Load file based on line number in sqlldr

I am trying to load header and detail records from a file. The only way I know the difference between the header and the detail records is the line number. The first line is always the header and the ...
Raja's user avatar
  • 31
1 vote
1 answer
2k views

Call trigger during SQL Loader insert

I'm trying to insert data from a file into an Oracle table using SQL loader. The primary key is populated by a sequence where the nextVal is called from an insert trigger. When I try using sqlldr, it ...
Raja's user avatar
  • 31
1 vote
3 answers
2k views

sqlldr running slow after indexes created

let me explain this.... I had ran 1 session of sqlldr while I run indexes into a table for 6 fields... now the indexes are completed but the sqlldr running very slow it loads one file after each 30 ...
hi4ppl's user avatar
  • 131
0 votes
2 answers
3k views

Using output value of column from function for another column in SQL*Loader

I have asked the same question on StackOveflow. Do not know, if this site is linked to that or not and thus whether that question will be seen by professionals here, so I am adding it here. Please ...
adbdkb's user avatar
  • 103
2 votes
3 answers
4k views

Repopulating Oracle tables using data from Excel/CSV file

I'm developing a Java EE application that utilizes Hibernate/JPA. Some of the data I want to use comes from another Business unit's spreadsheet that I need to periodically (re)load into 5 Oracle ...
jeff's user avatar
  • 133
2 votes
0 answers
7k views

sqlldr error - Invalid number

I am trying to load the following csv file into a table: TIMESTAMP ; SESSIONID;PROXY_SESSIONID; ACTION;USERNAME ;USERHOST ;OS_USERNAME ;CLIENT_ID ...
oz123's user avatar
  • 141
2 votes
1 answer
976 views

How does direct path load work when dataguard is enabled?

There's a few posts about direct path and dataguard but I just want to understand exactly how it actually works. How maybe I made an incorrect assumption, but if direct path means it writes to the ...
Codek's user avatar
  • 220
3 votes
1 answer
6k views

Example of loading into RDS from S3 using SQL*Loader

Does anyone have a working sample of loading data into an Amazon AWS RDS Oracle database using SQL*Loader where the source file is on S3? In principle it's clearly possible. The Amazon RDS Data ...
mdahlman's user avatar
  • 347
4 votes
2 answers
2k views

How make convincing case to DBA to use Oracle external tables for 500 MB to 5 GB files?

In our data feeds, we have a stack of XML files as well as numerous flat files to put into an Oracle11g database. We flatten the XML into delimited files, and load the whole set using SQLLoader. I ...
Andrew Wolfe's user avatar
4 votes
2 answers
4k views

Loading XML documents to Oracle 11g DB with control file

I am using Oracle 11g XML database and trying to load XML documents to this DB with a control file and the sqlldr utility. All these XML files have an element that contains a date string with time ...
Asif's user avatar
  • 41
4 votes
1 answer
17k views

Load Numerical Column with Variable Comma

I'm using sqlldr to load a file which has a numerical value as one of its fields. The problem is that in some of the records the number has commas whereas in other, it doesn't. So doing something ...
Isaac Kleinman's user avatar
2 votes
1 answer
2k views

Oracle SQL Loader - load file where record is composed of "n" delimiters

How would you write a control file for Oracle SQL Loader that treats each record as being composed of 3 commas? I have read the documentation, however I cannot find how to handle this scenario, ...
kloppers's user avatar
4 votes
1 answer
3k views

Use sqlldr control file to automatically create several tables in Oracle

I have a client who has a requirement that I load data from csv files into an Oracle database. Part of the requirement is that I use sqlldr and provide a control file to facilitate loading this data. ...
Phil's user avatar
  • 141
3 votes
1 answer
18k views

SQL*Loader-605: Non-data dependent ORACLE error occurred

As I try to load data into Oracle, I've encountered SQL*Loader-605: Non-data dependent ORACLE error occurred error. Data is (are?) in .txt file and its size is 95GB. Here are some more details ...
bonsvr's user avatar
  • 340