我插入一条语句INSERT INTO SSBAK.R_MIXSUB (ABCD,DN,HLRNUM,LRN,NOC,ROWSTATUS,TAG,TYPE) VALUES (39594,'5521120010',' ','05521120009',696,
2,0,0)数据库报错:
ERROR 位于第 1 行:
ORA-01502: 索引'SSBAK.R_MIXSUB_DN'或这类索引的分区处于不可用状态但是查索引状态
select distinct status from user_indexes
select distinct status from user_constraints
无invalid或disabled状态的索引和约束存在请教各位高人,问题原因是什么?
2,0,0)数据库报错:
ERROR 位于第 1 行:
ORA-01502: 索引'SSBAK.R_MIXSUB_DN'或这类索引的分区处于不可用状态但是查索引状态
select distinct status from user_indexes
select distinct status from user_constraints
无invalid或disabled状态的索引和约束存在请教各位高人,问题原因是什么?
并且select distinct status from user_indexes
select distinct status from user_constraints
无invalid或disabled状态的索引和约束存在
Rebuild the specified index
Rebuild the unusable index partition Generally, the following SQL manipulation language will be able to rebuild the unusable index:ALTER INDEX index_name REBUILD