Search code examples
oracleunixoracle9isql-loader

Questions on SQL* Loader commit range and display

As per my observation, when we load the data to Oracle tables using SQL* Loader, 64 records are committed at once, by default.

Could you please let me know if we can change this default limit of insertion/commit to number other than 64?

Also, can we avoid the display of loading, shown below on the console?

Commit point reached - logical record count 64
Commit point reached - logical record count 128
Commit point reached - logical record count 192
Solution

  • From the reference:

    rows -- number of rows in conventional path bind array or between direct path data saves
    (Default: Conventional path 64, Direct path all)

    So you'd specify rows=1024 or whatever on the command line or parameter file.

    As for avoiding the display, I don't think there's an option to suppress only the progress information. There is silent but that might be more than you want. Filter those out with grep if you don't want to see them.