4

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
Savitha
  • 405
  • 4
  • 15
  • 25

1 Answers1

3

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.

APC
  • 144,005
  • 19
  • 170
  • 281
Mat
  • 202,337
  • 40
  • 393
  • 406
  • Thank U Mat...:) I shall implement these and update on the output on Monday....Thanks again..:) – Savitha Oct 27 '12 at 06:31
  • Hi Mat...your reply helped me increase the commit point to maximum 1706 rows. I mean whetever range I give in "rows", say 2000, 5000, etc., it is always committing at 1706 rows. I couldn't understand this. Is this the maximum commit point it can reach? – Savitha Oct 30 '12 at 06:37
  • There's also the `bindsize` parameter that could influence this. Please read the docs about it. – Mat Oct 30 '12 at 06:42
  • Thanks a lot Mat...I am able to commit at a higher range now. :) – Savitha Oct 31 '12 at 10:08