Re: Fail to extend rollback segment ?

In article <546c6s$f71_at_news.cis.okstate.edu>, wshiang_at_a.cs.okstate.edu (WANG SHIANG HUEY) wrote:
> Hi,
> when I insert 200,000 records into a table from a query, I encounter
> the following errors.
> ORA-01562: failed to extend rollback segment (id = 1)
> ORA-01628: max # extents (121) reached for rollback segment RB_TEMP
> I have added a datafile size 20M (total is 35M)
> and increase the initial to 1M and next to 500K on ROLLBACK_DATA
> tablespace, but it didn't solve the problem.

Best thing to do for ALL rollback segs:

 alter rollback segment R01 OFFline ;
 drop rollback segment R01 ;
 create rollback segment R01 storage (initial 500K next 500K pctincrease 0);  alter rollback segment R01 ONline ;

Hope this helps.

R. Schierbeek, DBA                         ---|--- 
I'd rather be flying    _____________________ | _____________________
email: bytelife_at_worldonline.nl               (_)