This discussion is archived
10 Replies Latest reply: Jul 30, 2013 10:15 PM by 3cd7ad85-b56c-4a9c-ae91-83be047aac2c RSS

Pls help: SQL Loader loads only one record

3cd7ad85-b56c-4a9c-ae91-83be047aac2c Newbie
Currently Being Moderated

Hi!!!

 

 

I am trying to insert data into a table using SQL Loader.

At the command line, i have entered

 

 

>sqlldr userid=abc\abc control = 'contrl_file_name.ctl'

 

 

This does not perform any operation and simply hangs...table does not have any data...no data in log file ...

It simply shows the SQL Loader Release ...production...Copyright messages and does not halt.

 

 

Am new to SQL loader.... Kindly help

 

*************************************************************

Another problem:

 

I have my loading_data.dat file with multiple entries like the below which are records to be inserted for a single column in my table.

233207332711<EOFD><EORD> 233208660745<EOFD><EORD> 233200767380<EOFD><EORD>.....

 

My control file is like this:

continue_load data

infile loading_data.dat"

insert

into table T1

fields terminated by '<EOFD><EORD> '

(msisdn)

 

when I run the following sqlldr statement, it inserts just one record and says Load Completed- logical record count 1.

 

Why are my other records not getting inserted?

 

Message was edited by: 3cd7ad85-b56c-4a9c-ae91-83be047aac2c

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points