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명