OraFAQ Forum: Server Administration » Table reached maxextents

Home » RDBMS Server » Server Administration » Table reached maxextents (9i, solaris10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table reached maxextents [message #395120]

Tue, 31 March 2009 06:52

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

Report message to a moderator

Re: Table reached maxextents [message #395141 is a reply to message #395120]

Tue, 31 March 2009 08:12

joy_division
Messages: 4963
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.

Report message to a moderator

Re: Table reached maxextents [message #395198 is a reply to message #395120]

Tue, 31 March 2009 10:43

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.

Report message to a moderator

Re: Table reached maxextents [message #395255 is a reply to message #395120]

Tue, 31 March 2009 22:49

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

Report message to a moderator

Re: Table reached maxextents [message #395256 is a reply to message #395120]

Tue, 31 March 2009 22:51

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Table reached maxextents [message #395309 is a reply to message #395255]

Wed, 01 April 2009 02:16

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

DBA_TABLESPACES.ALLOCATION_TYPE

Regards
Michel

Report message to a moderator

Previous Topic:	Ramifications of ORA-01555 on Oracle Text index
Next Topic:	Patching error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 00:30:26 CDT 2024