Getting ORA-01512 when trying to generate statistics
492425Feb 25 2006 — edited Feb 25 2006The status of the index in dba_indexes is N/A... What does this status mean? I looked to some of the postings on web related to this error and it suggests to rebuild the index "Alter indix ....... rebuild; . My question is should I build the index or contact the schema owner to take a look at it, I am just a dba for the database. What is usually the approach in such cases in general how to dba's response to these. What if I buld it and inform schema owner in the morning? Will it cause any performance problem if they are not using this index? I am new to this dba world, suggest please.
select STATUS from dba_indexes where index_name = 'DILEE_ROAMING_DETAIL_IND01';
STATUS
--------
N/A
11:00:05 PM - GATHER_SCHEMA_STATS (Empty) completed for schema CAI
ERROR at line 1:
ORA-01502: index 'DILEE_BE.DILEE_ROAMING_DETAIL_IND01' or partition of such index is in unusable state
ORA-06512: at "SYS.DBMS_STATS", line 4479
ORA-06512: at "SYS.DBMS_STATS", line 4603
ORA-06512: at "SYS.DBMS_STATS", line 4725
ORA-06512: at "SYS.DBMS_STATS", line 4702