Commit/Rollback using SQL*Loader

Is there any way to make SQL*Loader treat the whole load process as one transaction. i.e., if any kind of exception (including bad records) occurs during the load process, SQL*Loader should rollback the whole transaction.

I am using the conventional method and by default the commit point under this method is 62 records. I thought about bumping up this number. But unfortunately, I am not in a position to know the upper limit of the number of records that can come in at any point of time.

Any ideas??

Thanks,

Murali Kazhipurath
(murali_at_jps.net) Received on Sun Feb 08 1998 - 00:00:00 CST