URGENT - MAX EXTENTS LIMIT REACHED!

[ggnanaraj]

In the alert log the following error occurs,

ORA-1632: max # extents 50 reached in index
INV.MTL_UNIT_TRANSACTIONS_N1

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?

Thanks.

With regards.

[hrishy]

Hi

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 ................

regards
hrishy

[ggnanaraj]

Thanks for pointing this out.

I've rectified the error with the following statement

ALTER INDEX INV.MTL_UNIT_TRANSACTIONS_N1 STORAGE (MAXEXTENTS 75);

Any suggestions?


With regards.

[pando]

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.