Commit point reached

[soans]

I am running someone else's sql loader scripts temporarily. I am getting the following message after 15 rows
in the log file every time I load the data
"Commit point reached - logical record count n"
where n is 15,30,.........
I am not getting such messages when I run my sql loader scripts.
Is this dependant on bindsize?

Thanks

 

[ManjulaMadhu]

yes, it's dependent on the bind size. It is the feedback message that shows that the load is progressing. you can suppress them by giving SILENT=(HEADER, FEEDBACK) or SILENT=ALL. this will stop displaying the feedback messages, but still write in the log file.