Help, rollback segment failed to extend.

While doing service at a customers database I wanted to delete 1.4 millions rows from a table and failed because the rollbacksegment failed to extend. I had to delete in batches of 50.000 commiting after each batch, even deleting 100.000 failed. The rowsize is 146 bytes. The table has 3 indexes, one pk and two nonuniques. No other users/sessions were active. At home, on a database with the same setup, experiments showed no problems. These were the errormessages I got:
ORA-01562: failed to extend rollback segment ID = num ORA-01628: max # of extents num reached for rollback segment num System: Oracle 8.05 on NT4 sp3.
The database is part of an application. When in production the db runs unattended at the customer. I make scripts for db-creation and all customers use the same setup.
Here is part of the scripts concerning rbs:

    create tablespace rbs
  datafile '<path>\rbs01.dbf' size 200m   default storage (initial 1m next 1m maxextents unlimited

       minextents 15 pctincrease 0);

    create public rollback segment rbs1   tablespace rbs
  storage(initial 1m next 1m minextents 15 maxextents 500 optimal 15m);     

    create public rollback segment rbs2   tablespace rbs
  storage(initial 1m next 1m minextents 15 maxextents 500 optimal 15m);     

    create public rollback segment rbs3   tablespace rbs
  storage(initial 1m next 1m minextents 15 maxextents 500 optimal 15m);

Now my questions:
What could have made the deletes fail at the customer database? What should I look for to find the reason? Is the the rbs setup described above bad in some way?

Thanks
Peter Received on Wed Aug 11 1999 - 07:44:23 CDT