Re: Which DML use more Rollback sapce?

Syed Faisal Shah <faisal_at_cyber.net.pk> wrote:

> gchen wrote:
> >
> > Can anyone tell me which DML (insert, update,delete) use more space in
> > rollback segments?
> >
 

> Delete takes the most space in rollback
If a record consists of two fields one of which being small integer and the other being varchar2(1500) then updating it will take more space then just deleting.

-- 
Sincerely Yours, Konstantin Kivi, Russia, konst_at_sirena.rinet.ru 
    aka <k-kivi_at_usa.net>, 2:5020/457.24_at_fidonet.org