Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-1631: max # extents 121 reached............
I used to run into this one fairly frequently with Oracle 7.x there were
several limits like, if your block size is 2k your max extents is 121. just
like your max number of datafiles is 32. Without rebuilding database (not a
good option) you can try exporting the table, dropping it and importing it
it (not a bad idea anyway if you are running a pre 8i version and you have
that many extents) If maintance window is real small try creating a temp
table to house data, create a view to replace table until you can schedule a
bigger window. I have had to do both and both work.
-ERIC-
"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 Tue Mar 26 2002 - 20:52:24 CST