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
3 answers

oracle sql loader loading data in different columns in same table

I have a sample csv file that contains data that i want to load in oracle table. The sample data is like 1,aa,b,c 2,x,yy,zzz 1,aa,b,c 2,x,yy,zzz These are two different records distinguished by first character as '1' and '2', for which I am having…
KAPIL KUMAR LALWANI
  • 1
  • 1
  • 2
0
votes
2 answers

sql loader - check for specific field value

I have a field called "FLOATVALUE" in csv/text file. I receive this file from third party, this has below possible values NULL {} Any number When I insert this value as below .... [OTHER FIELD CHECKS] isValid "nvl(:isValid,…
Shashi
  • 199
  • 1
  • 6
  • 19
0
votes
1 answer

Load multiple data files into multiple tables using single control file using sql loader

I have requirement to load billions of record into 5 different tables , each one of these tables have different data files. These 5 tables will be populated daily and will be truncated next day before loading fresh data. Que1 : How do I load data…
user2270413
  • 1
  • 1
  • 2
0
votes
2 answers

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

I am getting error when I try to load Incl_c.ctl, all other control files are loading perfectly fine. Here's the error: [navy10@sit ~]$ sqlldr navy10@studb10g Incl_C.ctl Password: SQL*Loader: Release 10.2.0.3.0 - Production on Wed Mar 27 10:26:52…
Navy
  • 59
  • 1
  • 4
  • 8
0
votes
3 answers

Delimeter files issues

I do have a flat file with not a fixed structure like name,phone_num,Address bob,8888,2nd main,5th floor,avenue road Here the last column Address has the value 2nd main,5th floor,avenue road but since the same delimeter , is used for seperating…
Aspirant
  • 2,238
  • 9
  • 31
  • 43
0
votes
2 answers

disabling c++ output message for sql loader

I have a C++ code in which I am using sql loader using system(). When SQL Loader executes while running the code, I got below mentioned messages which I want to disable: SQL*Loader: Release 10.2.0.1.0 - Production on Thu Mar 14 14:11:25…
sajal
  • 69
  • 1
  • 13
0
votes
2 answers

Oracle SQL loader - load inconsistent date formats in same column

A client site has supplied the following extract file for us to load into our database. The problem is, for certain rows (the second row for example) the CREATED_DATE and the LAST_UPDATE_DATE are in "dd Mmm YYYY..." date format when the rest the…
Nimbocrux
  • 509
  • 2
  • 10
  • 27
0
votes
2 answers

Failed to import LOB into Oracle using SQL Loader

I'm trying to export from SQL Server to Oracle a table that consists of an ID and a really long XML string stored as nvarchar(max). SQL Table -- CREATE TABLE MyStuff (MyID int, MyText nvarchar(max)) Oracle Table -- CREATE TABLE MyStuffImported (MyID…
Keith
  • 20,636
  • 11
  • 84
  • 125
0
votes
1 answer

How to know the number of rows loaded by sqlldr?

I have a table X and I'm loading data from many files to Table X using SQLLDR. I need to know how many rows got loaded into tables The CTL files contain many conditions, again writing the scripts for filtering and counting will affect the…
Rajeev
  • 1,196
  • 3
  • 14
  • 21
0
votes
1 answer

how to import from oracle?

friends I've tried to import data from oracle using command line by following command: expdp hr/Password1 DIRECTORY=dmpdir DUMPFILE=hr.dump i got the dump file but problem is it is not in readable form!and also i've try to export to another schema…
Thiyagu ATR
  • 2,224
  • 7
  • 30
  • 44
0
votes
1 answer

load csv file into multiple Oracle tables

I have created a control file using TOADs SQL* Loader Wizard. I have used specified following two tables to load the data but the after running the data has only loaded into one table and a dsc file is generated. Below is the control file I am…
Henry Rios
  • 1
0
votes
2 answers

SQL LOADER GIVING ERROR

I execute the command and get following message at console: ---------------------------------------------------------------------- SQLLDR APPS@VIS/APPS CONTROL= SQL*Loader: Release 9.2.0.1.0 - Production on Tue Sep 2 10:49:27 2003 Copyright (c)…
Orapps
  • 631
  • 2
  • 6
  • 8
0
votes
2 answers

SQL loader: join on other table

I just went through the online documentations, and found that when using SQL loader to load flat files, if you wish to make join on another table in order to get values from that table. It is not possible. We need to use external tables in this…
user613114
  • 2,731
  • 11
  • 47
  • 73
0
votes
1 answer

How to get count of success and failure insert while Loading data to a table in MySql?

I am using LOAD function to load data from a file to table. I want to know the count of success and failure insert into table. Also what will happen once we get a failure, the load process will stop or continue with further loading?
Abhilasha
  • 63
  • 8
0
votes
0 answers

No TNS Listener when using SQL*Loader

We use SQL*Loader for bulk loading, and we have written a shell script to do this. When I execute the script I am getting this error: SQL*Plus: Release 11.2.0.1.0 Production Copyright (c) 1982, 2009, Oracle. All rights…
vvekselva
  • 803
  • 3
  • 17
  • 34
1 2 3
…
67 68