<div>
Thanks pennnn! Outstanding answer!!! I added the OPTIONS (ERRORS=100) in my Control File as line 1 and the loader worked great, (except for the 70 errors I received), so I am off to resolve those now.<br />
<br />
Thanks again for the fast response.<br />
<br />
-Steve
</div>


Thanks pennnn! Outstanding answer!!! I added the OPTIONS (ERRORS=100) in my Control File as line 1 and the loader worked great, (except for the 70 errors I received), so I am off to resolve those now.

Thanks again for the fast response.

-Steve

<div>
<div class="content wysiwyg-content">
I am trying to load several thousand lines of data and I am getting about 95% of the data loaded before the load bombs due to going over the &quot;Errors Allowed = 50&quot; I have copied a portion of my log file below that shows the Errors allowed setting. I would like to change this to 100, where would I do this?<br />
<br />
Thanks<br />
-Steve<br />
<br />
<br />
---------------<br />
SQL*Loader: Release 9.2.0.1.0 - Production on Thu Nov 21 12:43:06 2002<br />
<br />
Copyright (c) 1982, 2002, Oracle Corporation. &nbsp;All rights reserved.<br />
<br />
Control File: &nbsp; xyz.ctl<br />
Data File: &nbsp; &nbsp; &nbsp;xyz.Dat<br />
&nbsp; Bad File: &nbsp; &nbsp; xyz.bad<br />
&nbsp; Discard File: &nbsp;none specified<br />
&nbsp;<br />
&nbsp;(Allow all discards)<br />
<br />
Number to load: ALL<br />
Number to skip: 0<br />
Errors allowed: 50<br />
Bind array: &nbsp; &nbsp; 64 rows, maximum of 256000 bytes<br />
Continuation: &nbsp; &nbsp;none specified<br />
Path used: &nbsp; &nbsp; &nbsp;Conventional
</div>
</div>


I am trying to load several thousand lines of data and I am getting about 95% of the data loaded before the load bombs due to going over the "Errors Allowed = 50" I have copied a portion of my log file below that shows the Errors allowed setting. I would like to change this to 100, where would I do this?

Thanks
-Steve


---------------
SQL*Loader: Release 9.2.0.1.0 - Production on Thu Nov 21 12:43:06 2002

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Control File:   xyz.ctl
Data File:      xyz.Dat
  Bad File:     xyz.bad
  Discard File:  none specified
 
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array:     64 rows, maximum of 256000 bytes
Continuation:    none specified
Path used:      Conventional

How do I change the Max Errors Allowed in SQL Loader?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.