ORA-25150: ALTERING of extent parameters not permitted

ORA-25150: ALTERING of extent parameters not permitted

Error:

SQL> alter table TEST.TEST storage (maxextents 1024);
alter table TEST.TEST storage (maxextents 1024)
*
ERROR at line 1:
ORA-25150: ALTERING of extent parameters not permitted

Solution
1. Check the EXTENT_MANAGEMENT of your Tablespaces with the following query:

select tablespace_name, extent_management, allocation_type from dba_tablespaces;

TABLESPACE_NAME                EXTENT_MAN ALLOCATIO
------------------------------ ---------- ---------
SYSTEM                         LOCAL      SYSTEM
SYSAUX                         LOCAL      SYSTEM
UNDOTBS1                       LOCAL      SYSTEM
TEMP                           LOCAL      UNIFORM
USERS                          LOCAL      SYSTEM

2. If the Tablespace of the Table “TEST” is LOCAL Extent Management ( with Allocation Type SYSTEM or UNIFORM)
then, you don’t have to manage the Size of the Extents. Oracle will do it for you.

Please find the link for more details: http://www.orafaq.com/node/3

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.