Home » RDBMS Server » Server Utilities » Commit point reached - logical record count (Oracle9i)
Commit point reached - logical record count [message #311000] Thu, 03 April 2008 03:47 Go to next message
hari_bk
Messages: 110
Registered: March 2006
Senior Member
Hi
I am trying to import data into the table from CSV file using SQLLDR. I gave the following command

sqlldr RFC27393/RFC27393@OHRONT control=TABLES.CTL data=Tables.csv log=Tables.Log

Control file contents are here.

LOAD DATA
INFILE 'C:\Tables\Tables.csv'
discardfile 'bad.txt'
INTO TABLE R27393
FIELDS TERMINATED BY ','
(Table_Name,Table_Name1)

I am getting the message Commit point reached - logical record count80 and export is terminating coming back to $ prompt after loading only 64 rows and my table ia having 1000 rows.

Can anyone suggest how to solve this problem and load complete data into table.

Thanks
HK
Re: Commit point reached - logical record count [message #311011 is a reply to message #311000] Thu, 03 April 2008 04:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to post your log.

Regards
Michel
Re: Commit point reached - logical record count [message #311034 is a reply to message #311000] Thu, 03 April 2008 04:59 Go to previous message
hari_bk
Messages: 110
Registered: March 2006
Senior Member
Hi I am able to insert whole csv file into table now.

I added this into my CTL :

OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS

My CTL file entry is

LOAD DATA
INFILE 'C:\Tables\Tables.csv'
discardfile 'bad.txt'
INTO TABLE RFC27393
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(Table_Name,Table_Name1)

Thanks
Hari
Previous Topic: Data uploading from legacy system to Oracle database
Next Topic: concatenation using sql loader
Goto Forum:
  


Current Time: Wed Dec 07 10:29:17 CST 2016

Total time taken to generate the page: 0.13219 seconds