Top Posts Tagged with #ora-01502

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';

#sqlexception #sql #ora-01502

•18+ Adults Only

Watch Anya Live on Cam

Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.

✓ Live Streaming✓ Interactive Chat✓ Private Shows✓ HD Quality✓ Free Actions

Free to watch • No registration required • HD streaming

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

#drop index #how to resolve #index or partition of such index is in usable state #ora-01502