#ora-01502

[rabatfirstsight]

SQLException ORA-01502 partition of such index is in unusable state

reference: https://dba.stackexchange.com/questions/3754/ora-01502-index-or-partition-of-such-index-is-in-usable-state-problem

for DBA:

SELECT 'ALTER INDEX '||OWNER||'.'||INDEX_NAME||' REBUILD;' FROM DBA_INDEXES WHERE STATUS = 'UNUSABLE';

for non-DBA:

SELECT 'ALTER INDEX ' || INDEX_NAME || ' REBUILD;' FROM USER_INDEXES WHERE STATUS = 'UNUSABLE';

[blogstxr]

How to resolve ORA-01502: index or partition of such index is in usable state

How to resolve ORA-01502: index or partition of such index is in usable state

drop index index_name;

delete from table where …..; — delete the duplicated records

create index index_name on table(col1,col2);

insert into table(….)values(…); — insert back the duplicate record with only 1 record

Above is the sequence used to resolved my work which have duplicate rows of data which i’m unable to insert a new record into the table. So I have to remove the duplicate rows…

View On WordPress