| How To ignoe MAX errors [message #71821] |
Thu, 16 January 2003 03:12  |
Tom
Messages: 67
Registered: June 1998
|
Member |
|
|
Hi.. what is the systax that i need to use
in order that the SQLLOADER wont stop at 50 (default) errors ...
thanks
|
|
|
|
| Re: How To ignoe MAX errors [message #71823 is a reply to message #71821] |
Thu, 16 January 2003 05:02  |
Albert
Messages: 20
Registered: October 2002
|
Junior Member |
|
|
From Oracle Documentation
-----
Default: To see the default value for this parameter, invoke SQL*Loader without any parameters, as described in Invoking SQL*Loader.
ERRORS specifies the maximum number of insert errors to allow. If the number of errors exceeds the value specified for ERRORS, then SQL*Loader terminates the load. To permit no errors at all, set ERRORS=0. To specify that all errors be allowed, use a very high number.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
