Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Tablespace

Tablespace

From: James <james_vora_at_infinium.com>
Date: 1998/06/09
Message-ID: <6lk3oe$ki1$1@whqnews01.infinium.com>#1/1

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 Received on Tue Jun 09 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US