在线创建索引的脚本没跑完,然后“CRTL+C” 取消了,再次创建的时候报 ORA-08104:
处理过程:
1、找出索引的 object_id
2、执行下面脚本
DECLARE
RetVal BOOLEAN;
OBJECT_ID BINARY_INTEGER;
WAIT_FOR_LOCK BINARY_INTEGER;
BEGIN
OBJECT_ID := 68100;
WAIT_FOR_LOCK := NULL;
RetVal := SYS.DBMS_REPAIR.ONLINE_INDEX_CLEAN ();
COMMIT;
END;
/
3、重新创建索引