| SqlLoader [message #71649] |
Mon, 09 December 2002 15:06  |
Prabhu
Messages: 26
Registered: October 2001
|
Junior Member |
|
|
Hi...
I'm loading data from flat file to Oracle DB using
SQL Loader. If the data has some problem and if it skips (due to data problem) 100 rows the loader terminates.But i want to continue till the end of file even if loader doesnt able to laod a row into table.
Is there any parameter to be set for this ? where and how? can any give me exact syntax.
thanks in advance
Prabhu
|
|
|
|
| Re: SqlLoader [message #71650 is a reply to message #71649] |
Mon, 09 December 2002 15:12  |
satish
Messages: 112
Registered: September 2000
|
Senior Member |
|
|
As the first line in your control file, enter: OPTIONS (ERRORS=9999999)
99999 means the number of allowed errors before exiting.
Satish.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
