Re: can I update data without using rollback segment?

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