Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Tablespace
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