索引错误 ORA-01502: index ‘index_name' or partition of such index is in unusable state 这个错误一般是因为索引状态为UNUSABLE引起的 此时需要修改索引即可 : ALTER INDEX INDEX_NAME REBUILD .
INDEX_TYPE, TABLESPACE_NAME, TABLE_TYPE, STATUS FROM DBA_INDEXES WHERE STATUS = 'UNUSABLE'
最近在做Oracle数据清理,在对分区表进行数据清理时,采用的方法是drop partition,删除的过程中,没有遇到任何问题,大概过了10分钟,开发人员反馈部分分区表上的业务失败。具体错误为: ORA-01502错误:索引或这类索引的分区处于不可用状态(英文:ora-01502:index ‘schema.index_name’ or partition of such index is in...
ORA-01502: index ‘index_name' or partition of such index is in unusable state ORA-06512: at line 168 错误原因: 这个错误一般是因为索引状态为UNUSABLE引起的。你可以通过下面SQL,查看索引的状态 SELECT OWNER, INDEX_NAME,STATUS FROM DBA_INDEXES WHERE INDEX_NAME='INDEX_NAME' SELECT OWNER, INDEX_NA...
索引错误 ORA-01502: index ‘index_name' or partition of such index is in unusable state 错误原因: 这个错误一般是因为索引状态为UNUSABLE引起的。你可以通过下面SQL,查看索引的状态 SELECT OWNER, INDEX_NAME,STATUS FROM DBA_INDEXES WHERE INDEX_NAME='INDEX_NAME';...
ORA-01502: index ‘index_name' or partition of such index is in unusable state ORA-06512: at line 168 错误原因: 这个错误一般是因为索引状态为UNUSABLE引起的。你可以通过下面SQL,查看索引的状态 SELECT OWNER, INDEX_NAME,STATUS FROM DBA_INDEXES WHERE INDEX_NAME='INDEX_NAME' ...
ORA-01502: index 'NIKU.CMN_SEC_ASSGND_OBJ_PERM_PK' or partition of such index is in unusable state ORA-06512: at "NIKU.CMN_SEC_ASSIGN_INST_RIGHT_SP", line 76 ORA-06512: at line 1 This error can also occur during an upgrade such as: ...
index "SYS.IX_target" or partition of such index is in unusable state 解决方案: --查询UNUSABLE状态的index select index_name, status, owner from dba_indexes where STATUS = 'UNUSABLE'; --组装重新编译index的sql语句 select 'alter index '||owner||'.'||index_name||' rebuild;' from dba_...
描述: index 'string.string' or partition of such index is in unusable state 原因: 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 動作: DROP the specified index, or REBUILD the specified index, or REBUI...
Oracle Error: ORA-01502: index <index name> or partition of such index is in unusable stateORA-06512: at ...ORA-06512: at line 2ABINITIO(DB10031): SQL: ECI_SCHEMA.DL_UPD_RACN_FIELDS:var_rev_item_earn_dtl_id_nbr,:var_plan_racn_nbr,:var_racn_nbrABINITIO(DB10031): Parse Error...