Re: can I update data without using rollback segment?

Tom,

Unfortunately, I have to object. First, the original poster means rollback segments, not redo logs. Second, NOLOGGING not exactly turns off logging for DML. Third, Oracle does not allow just to turn off rollback segments, because in this case other transactions would have to read uncommitted data.

There is no way and there is no need to get rid of rollback segments because it is one of the features that makes Oracle exceptional. If the performance is a concern, there is a number of things that can be tuned to make things faster. One of the obvious things is to put rollback segments on another disk.

Regards
Karen.

Tom Best wrote:

> You could do this:
>
> alter table <tablename> nologging
>
> then do you updates, and then:
>
> alter table <tablename> logging
>
> But be aware that that affects all sessions modifying that table.
>
> HTH,
> Tom Best
>
> <wy_at_fudan.edu> wrote in message news:8mmgt1$2jo$1_at_nnrp1.deja.com...
> > when I update large data,it always raise rollback segment has reach the
> > max extends.
> > I know I can specify a larger rollback segment to the transaction.
> > but I think it also cost a lot.
> > sometime I want to update the data without using rollback segment or I
> > don't need do it in a transaction.
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Mon Aug 07 2000 - 00:00:00 CDT