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

From: Paul Drake <paled_at_comcast.net>
Date: Sun, 24 Mar 2002 04:53:37 GMT
Message-ID: <3C9D5C7C.4030402@comcast.net>

Ashadul Khan wrote:

> 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

I'll guess that the version of the database is 7.3, or was created with 7.3 and upgraded.
Depending upon the db_block size, 121 could have been the maxextents set by default for the tablespace at creation time. You can alter the storage for the table with the ALTER TABLE statement.

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76956/schema.htm#1353 http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/state25d.htm#2068535

hth.

Paul Received on Sat Mar 23 2002 - 22:53:37 CST