Re: ORA-01631 problem

From: Claes Nordfeldt <cnordfel_at_seisy.abb.se>
Date: 1997/12/22
Message-ID: <349E31D7.2A798715@seisy.abb.se>#1/1

Hi Bong,

As the error text says:

01631, 00000, "max # extents (%s) reached in table %s.%s" // *Cause: A table tried to extend past maxextents // *Action: If maxextents is less than the system maximum, raise it. Otherwise,
// you must recreate with larger initial, next or pctincrease params

Regards
Claes

Bong Khin Fah wrote:

> hi everybody,
>
> how would you normally deal with
> ORA-01631 max # of extents 'num' reached in table 'name' error ?
>
> the current maxextents of tablespace = 121, pctincrease = 0.
>
> thank you
>
> Bong Khin Fah
> Sarawak Information Systems Sdn. Bhd.
Received on Mon Dec 22 1997 - 00:00:00 CST