java.sql.SQLException: ORA-01502: index 'GD_RP.PK_TB_UC_TASK' or partition of such index is in unusable state

SELECT OWNER, INDEX_NAME,STATUS  FROM DBA_INDEXES WHERE INDEX_NAME='PK_TB_UC_TASK' 
SELECT OWNER, INDEX_NAME,STATUS  FROM ALL_INDEXES WHERE INDEX_NAME='PK_TB_UC_TASK' 
SELECT  INDEX_NAME,STATUS  FROM USER_INDEXES WHERE INDEX_NAME='PK_TB_UC_TASK' 

ALTER INDEX PK_TB_UC_TASK REBUILD

2 Responses

1. Nike Air Max 90 moire

   I have been exploring for a little bit for any high quality articles or blog posts in this kind of area . Exploring in Yahoo I ultimately stumbled upon this site. Studying this info So i am glad to show that I’ve a very good uncanny feeling I found out just what I needed. I so much definitely will make certain to do not disregard this web site and give it a look regularly.

   March 13th, 2016 Reply
2. asics 2000 gt

   Hi there, You’ve done a fantastic job. I will definitely digg it and personally recommend to my friends. I’m confident they’ll be benefited from this site.

   March 13th, 2016 Reply