-
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.
-
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
-
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.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|