| SQL Loader stops before end of file [message #442] |
Tue, 12 February 2002 16:29  |
Jason
Messages: 32
Registered: February 1999
|
Member |
|
|
I have a file with 11005 lines, I wrote a short load that shall place the data into my table, but it always stops at:
"Commit point reached - logical record count 4750"
and clue how i can tell if I'm running out of space in the db, or I need a special switch in my sqlldr command to exceed so many records.
thank you
|
|
|
|
| Re: SQL Loader stops before end of file [message #452 is a reply to message #442] |
Wed, 13 February 2002 07:08  |
INTROV
Messages: 20
Registered: February 2002
|
Junior Member |
|
|
|
When running your sqlldr you might have specified to write to log file. Check that log file. There might be more than 50 errors in the data file as the sqlldr when executed writes these errors to the log file. The max limit of errors by default is 50. This can be raised to higher value but that is not a good idea as the dataload will not load if there is any problem in the data. The log file gives you the information what went wrong.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
