Re: Tablespace

From: <andreas.prusch_at_sintec.de>
Date: Wed, 10 Jun 1998 05:48:38 GMT
Message-ID: <6ll6nn$8dm$1@nnrp1.dejanews.com>

If you want to change the storage clause of rollback segments you use the command 'alter rollback segment rbs storage (maxextents unlimited);' or 'alter rollback segment rbs storage (maxextents 100);'. Probably, for unlimited rollback segments you have to set the init parameter unlimited_rolbacksegments=true. For the name of the rollback segment query the view dba_rollback_segs where segment_id = rbs_num.

Andreas Prusch

In article <6lk3oe$ki1$1_at_whqnews01.infinium.com>, "James" <james_vora_at_infinium.com> wrote:
>
> I am getting the following Oracle error whilst populating the tables in
> Oracle 7.3. Can someone guide me how to change MAXEXTENTS or
> PCTINCREASE, and what parameter to use.
>
> ORA-01628 max # of extents num reached for rollback segment num
>
> Cause: An attempt was made to extend a rollback segment that already has
> reached its maximum size or space could not be allocated in the data
> dictionary
> to contain the definition of the object.
> Action: If possible, increase the value of either the MAXEXTENTS or
> PCTINCREASE initialization parameters or find the data dictionary
> table lacking space and alter the storage parameters, as described in the
> Oracle7 Server Administrator's Guide.
>
> Copyright (C) 1995, Oracle Corporation
>
> Thanks
>
> James
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 10 1998 - 00:48:38 CDT