ORACLE
ORA-01502
구름너머
2006. 9. 7. 11:24
1.오라클 에러..
ORA-01502: index 'IDX_AADB_01' or partition of
such index is in unusable state
2.오라클 핼프
01502, 00000, "index '%s.%s' or partition of such index is in unusable state"
// MERGE: 1489 RENUMBERED TO 1502
// *Cause: An attempt has been made to access an index or index partition
// that has been marked unusable by a direct load or by a DDL
// operation
// *Action: DROP the specified index, or REBUILD the specified index, or
// REBUILD the unusable index partition
3.문제되는 인덱스 찾기.
select index_owner,index_name,partition_name,STATUS
from dba_ind_partitions
where index_owner='BILL'
and index_name = 'IDX_AADB_01'
--and status = 'unUSABLE'
4.unUSABLE 를 rebuild한다.
==> alter index 인덱스명 rebuild 혹은
alter index 인덱스명 rebuild partition명