Skip to main content
Database Administrators

Questions tagged [sql-loader]

Ask Question

SQL*Loader is a bulk loader for Oracle

27 questions
Newest Active Bountied Unanswered
-1 votes
1 answer
169 views

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
  • 1
0 votes
0 answers
98 views

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
0 votes
2 answers
2k views

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
  • 9
0 votes
2 answers
119 views

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
216 views

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
  • 430
0 votes
1 answer
2k views

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
792 views

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
2k views

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
  • 11
0 votes
1 answer
1k views

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
428 views

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
  • 11
2 votes
1 answer
1k views

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
  • 23
3 votes
2 answers
10k views

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
  • 31
2 votes
0 answers
516 views

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
  • 121
1 vote
1 answer
3k views

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

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

15 30 50 per page
1
2