ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-08104: this index object 93996 is being online built or rebuilt

ORA-08104: this index object 93996 is being online built or rebuilt

原创 Linux操作系统 作者:why566 时间:2010-07-08 16:47:11 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-07-04

  • 博文量
    46
  • 访问量
    88998