Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rollback space
I beg to differ on commiting after every 'x' rows. I always prefer to
commit once at the end of the transaction. Commiting often is
definitely more work plus there is always the chance of the dreaded
ORA-01555 "Snapshot too old" error.
In my ETL procedures every insert and update is time stamped and hence
it can be identified.
Thanks
Manish
Received on Wed Feb 02 2005 - 12:39:43 CST