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

You can't if you use one insert statement. You can if you break up the insert and do multiple inserts with commits in between. That assumes you can segment the data. You could also use a PL/SQL or PRO*C loop to insert one or a few records at a time, and commit periodically. If you're loading from a file, sqlloader would handle it for you.

-- 
---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.