Home » RDBMS Server » Server Administration » Table reached maxextents (9i, solaris10)
Table reached maxextents [message #395120] Tue, 31 March 2009 06:52 Go to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi,

I have one table "AR_TAX_EXTRACT_SUB_ITF" for which I am getting error :-
ORA-1631:max # extents 1000 reached in table APPS.AR_TAX_EXTRACT_SUB_ITF.

upon investigation I found the following from dba_tables:-
==============
TABLE_NAME TABLESPACE_NAME MAX_EXTENTS
------------------------------ ------------------------------ -----------
AR_TAX_EXTRACT_SUB_ITF ARD 2147483645
AR_TAX_EXTRACT_SUB_ITF APPLSYSD 1000

From dba_tablespaces:-
=============================
TABLESPACE_NAME MAX_EXTENTS
------------------------------ -----------
APPLSYSD 1000
ARD 2147483645

Please advice is there is any solution as how to fix the issue.


Pokhraj
Re: Table reached maxextents [message #395141 is a reply to message #395120] Tue, 31 March 2009 08:12 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Alter the table to raise the max extents. You can find it in the docs under the ALTER TABLE command.
Re: Table reached maxextents [message #395198 is a reply to message #395120] Tue, 31 March 2009 10:43 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

Hi Pokhraj,

Here is the command to alter the max extents for a table.

ALTER TABLE <owner>.table STORAGE ( MAXEXTENTS UNLIMITED);

If the above command throws error you have to check the extent allocation policy,

because

MAXEXTENTS clause not allowed for tablespaces with autoallocate or uniform extent allocation policy

Regards,
Seenu.
Re: Table reached maxextents [message #395255 is a reply to message #395120] Tue, 31 March 2009 22:49 Go to previous messageGo to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi Seenu,

Could you please advice as how to check the extent allocation policy if in case its throws an error.

Pokhraj
Re: Table reached maxextents [message #395256 is a reply to message #395120] Tue, 31 March 2009 22:51 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

Are both SEARCH of this forum & GOOGLE broken for you?
Re: Table reached maxextents [message #395309 is a reply to message #395255] Wed, 01 April 2009 02:16 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBA_TABLESPACES.ALLOCATION_TYPE

Regards
Michel
Previous Topic: Ramifications of ORA-01555 on Oracle Text index
Next Topic: Patching error
Goto Forum:
  


Current Time: Sun Dec 04 18:28:10 CST 2016

Total time taken to generate the page: 0.08730 seconds