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