SQL> alter index IN_CLIPINFO_PATH rebuild online;
alter index IND_TEST_ID rebuild online
*
ERROR at line 1:
ORA-08104: this index object 93996 is being online built or rebuilt
select object_id,status from dba_objects where object_name=upper('IN_CLIPINFO_PATH');
Oracle10g可以用这种方法
DECLARE
RetVal BOOLEAN;
OBJECT_ID BINARY_INTEGER;
WAIT_FOR_LOCK BINARY_INTEGER;
BEGIN
OBJECT_ID := 57394;
WAIT_FOR_LOCK := NULL;
RetVal := SYS.DBMS_REPAIR.ONLINE_INDEX_CLEAN ();
COMMIT;
END;
/
alter index IN_CLIPINFO_PATH rebuild online nologging;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7478833/viewspace-667596/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7478833/viewspace-667596/