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 -> Re: ORA-1631: max # extents 121 reached............

Re: ORA-1631: max # extents 121 reached............

From: x <knannestxxx_at_tiscalixxx.noxxx>
Date: Sun, 24 Mar 2002 08:42:22 GMT
Message-ID: <Ojgn8.8901$N77.140614@news.world-online.no>


If you are running Oracle 7, you need to recreate the table with storage parameters (initial and next extent).
You should also consider changing default values for the tablespace(s). The consepts manual should give you some hints.

"Ashadul Khan" <akhi_at_starpower.net> wrote in message news:a7ichd$oui$1_at_bob.news.rcn.net...
>
> Hi.
>
>
>
> I have a table with 9000 rows. When I tried to insert some record I'm
> getting this error.
>
>
>
> ORA-1631: max # extents 121 reached in ..
>
>
>
> I alter the table with the storage clause unlimited. But still giving me
the
> same error. Any idea what can I do to fix it?
>
>
>
> Thanks
>
> akhi_at_starpower.net
>
>
Received on Sun Mar 24 2002 - 02:42:22 CST

Original text of this message

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