This content has been marked as final. Show 2 replies
1 person found this helpful
bharathDBA wrote:Hi Bharath,
I'm running an SQLLDR script to populate a table from and input datafile consisting of 80000 odd records.
Only about 30000 records are getting loaded into the table.
When I tried to list all the bad records in the .bad file generated,I could only see the first 50 records.
Is there a buffer size which limits this? if yes,how to increase the buffer size to get a list of all the 50000 bad records.
Can someone please help me with this...
Edited by: bharathDBA on Nov 21, 2012 10:54 PM
Edited by: bharathDBA on Nov 21, 2012 10:55 PM
Edited by: bharathDBA on Nov 22, 2012 12:09 AM
by default sqlldr stops after 50 errors.
In order to allow a higher number you need to specify the number of errors allowed while running sqlldr.
You can do like this:
In this case up to 999999 errors will be inserted in your bad file.
sqlldr userid=user/pass control=yourfile.ctl errors=999999
Thanks Al.It worked.