Re: Commits in a middle of a transaction

Kris Rahl wrote:
>
> Does anyone know if there is a way to commit partway through the
> completion of a transaction? We have a 20,000 row insert and was
> wondering if a commit can be forced easily before it's completed.
>
> Thanks,
> Kris Rahl
> Krahl_at_evolving.com

Whenever you do a commit, the transaction is ended, so technically the answer is no.

However, if you want to commit the INSERTs you are doing before all 20,000 rows have been inserted, you can simply do an explicit COMMIT at any time.

Keep in mind that doing incremental commits may have an effect if the load does not complete - you will have the rows that have been committed to the database before the load ended, but not others - so you should plan a way to recover from this potential situation.

Hope this helps.

• Rick Greenwald