In the alert log the following error occurs,
ORA-1632: max # extents 50 reached in index
A similar error appears in the client application also, causing a rollback.
The tablespace on which this index has AUTOEXTEND set to ON, but the ORA erros is that the max extents 50 has been reached.
How do I overcome this?
you got the concept wrong autoextend refers to the physical datafiles .use alter index rebuild command .......for that index and specify a higher max extents.................autoextend has nothin to do with autoextend ................
Thanks for pointing this out.
I've rectified the error with the following statement
ALTER INDEX INV.MTL_UNIT_TRANSACTIONS_N1 STORAGE (MAXEXTENTS 75);
ORA-01632 max # extents (string) reached in index string.string
Cause: An index tried to extend past MAXEXTENTS.
Action: If the value of MAXEXTENTS in the index storage clause is less than the maximum (based on your block size), raise it. Otherwise, re-create the index with larger extent sizes so that the total number of extents falls below the maximum.