Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Rollback
"Joseph Manuel Camilleri" <jm_c_at_bov.com> schrijfbewerkingen: > I am trying to perform an UPDATE on an oracle table using SQLPLUS script
> under Oracle 7.0 on all the rows in the table (i.e. the UPDATE has no WHERE
> clause). I keep getting problems with the size of the rollback segment.
>
> Is there someway I can turn off the rollback facility for this update only?
>
> Thanks.
>
> To reply please remove the underscore from my e-mail address. It should read
> jmc_at_bov.com
>
>
>
>
No. you can't. Rollback information is not only kept for your update,
but also for read consistency for other sessions: while
you are updating, Oracle shows other session the unchanged records by
retrieving the old values from the rollbacksegments.
Received on Mon Mar 16 1998 - 00:00:00 CST