ORA-25150 Altering of extent parameters not allowed
864251Jun 20 2011 — edited Jun 20 2011I had created an index as below
SQL> create index sys.emp_name_idx
2> on sys.emp(emp_name)
3> pctfree 30
4> storage( initial 200k next 200k pctincrease 0 maxextents 50)
5> tablespace indx;
Index Created.
Now i am trying to alter storage parameters of the index as below:-
SQL> Alter index emp_name_idx
2> storage( next 400k maxextents 100);
ERROR AT LINE 1
ora 25150 - aLTERING OF EXTENT PARAMETERS NOT PERMITTED
PLZ HELP!!!
Edited by: UNMESH on Jun 20, 2011 1:45 AM