Re: can I update data without using rollback segment?

In article <8mmgt1$2jo$1_at_nnrp1.deja.com>,   wy_at_fudan.edu wrote:
> 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.
>

Nologging of a table only impact redo not rollback.

Depending on the size of your db and jobs - A possible solution is to make a ROLL_BIG with a massive initial and next extent and let the thing grow. ie 1 GB initial and 1 GB next. This only works if you have the dasd.

What we do: We have processes which insert/update/delete millions of row each night. We use cursor processing to break up the transaction (ie update.... where rowid < 5000) and do periodic commits. Without doing this, our rollbacks needed to be in excess of 24 GB.

HTH..........

--
Doug Coan
Oracle Certified Professional DBA


Sent via Deja.com http://www.deja.com/
Before you buy.