Ora-01632 Max # extents in index
426357Jan 10 2005 — edited Jan 10 2005I receive the error ora-01632 Max # Extents 1000 reached in index idx_tender_detail_hist
I think the soulution is :
"alter index idx_tender_detail_hist storage (maxextents 2000);"
But I don't know the consequences of doing this solution. My block size is 4096K
Here is some info I was able to get from database:
________________________________________________
Segments within 10% of Max Extents
Current Max % Extents
Segment Type Extents Extents Remaining
------------------------------------------ ---------- ------- ------- ---------
SYS.1.291 CACHE 1 0 ####
CASHW3.IDX_TENDER_DETAIL_HIST INDEX ###### 249 ####
CASHW3.IDX_SEC_LOG INDEX 8,024 249 ####
CASHW3.CFW_TENDER_DETAIL_HIST TABLE 5,119 249 ####
CASHW3.CFW_RECEIPT_HIST TABLE 4,277 249 ####
CASHW3.CFW_SECURITY_LOG TABLE 1,344 249 -440