Re: controlling SQLLdr's commit operations

There is an upper limit on the bind array size. On most UNIX plaforms and Windows NT, this limit is 20MB. You can't have a bind array larger than this. So, if all your data for one load is not accomodated within 20MB, you can't use the bind array size to effect commit at the end of the transaction.

Also, keep in mind that the larger the bind array, the larger the rollback segment needs to be.

If the "commit only at the end" is an absolute requirement of your application, you can use the staging tables as suggested by Ron Reidy. Staging tables are very commonly used for similar purpose.

For more details, you can refer to SQL*Loader: The Definitive Guide, by O'Reilly.

Sanjay Mishra
Co-Author, SQL*Loader: The Definitive Guide Received on Tue Nov 13 2001 - 18:17:56 CET