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

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply