This content has been marked as final. Show 4 replies
try to post the control file that you are using with table structures and some sample data to work on. most probably you are using a control file that has line of code
while your data file is not formated by comma or delimited by comma.
FIELDS TERMINATED BY ","
SQL Loader has a default of 50 errors that are allowable after which the loader process exits.
You can increase the limit using the ERRORS CLause.
In the case of the above control file, the execution would quit after 999 records have errors in them.
SQLLDR CONTROL=foo.ctl, LOG=bar.log, BAD=baz.bad, DATA=etc.dat USERID=scott/tiger, ERRORS=999 , LOAD=2000, DISCARD=toss.dis, DISCARDMAX=5
If the file is pretty large and you want all errors be allowed, use a very large number for ERRORS.
Also, take a look at the bad file.. Sometimes an error in the control (like wrong column order..) file might cause all the records to error out.
Check this link and search for ERRORS : http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch04.htm
Thank you so much, it set error= 4000. it works fine.
sheebaann,1 person found this helpful
You might also want to check the log file / table to make sure all the records have not been errored out.
i.e.... If there are 300 records in a file and an error in the control file.. with ERRORS=4000, all records will be errored out, but the load would be complete...(which is not what you want..)
If the question is answered, please mark the question as answered and mark the answer correct...:)