| Commit point reached - logical record count [message #311000] |
Thu, 03 April 2008 03:47  |
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 #311034 is a reply to message #311000] |
Thu, 03 April 2008 04:59  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
