1,295   Oracle

报错

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

可能是索引状态unusable了,查看以下

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' 

果然全部是unusable,重建索引解决


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.

    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.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *