hi all,


I have a table with about 20million records.

I do a update of all records in a single update statement.

So i get this unable to extend the rollback segment error

adding a datafile will solve the problem i guess.

But is there any way of temporary stopping of writing into rollback segment before updating and resuming it after the update statement.

thanx