Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-1631: max # extents 121 reached............
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