kill rebuilt index

腳本内容

cnsz081302:cch > more cch_rebuild_index01.s*

::::::::::::::

cch_rebuild_index01.sh

cd $HOME/wc

sqlplus /nolog @$HOME/wc/cch_rebuild_index01.sql

cch_rebuild_index01.sql

conn / as sysdba

spool cch_rebuild_index01.log

set timing on

set time on

set echo on

alter index cchlogtmp.IDX_MAIN_INFO_T_SYSID_SMS_3 rebuild online parallel 8;

alter index cchlogtmp.IDX_MAIN_INFO_T_SYSID_SMS_3 noparallel;

spool off

exit

日志資訊：

cnsz081302:cch > more nohup.out

SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 21 21:23:15 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected.

21:23:15 sys@cch>alter index cchlogtmp.IDX_MAIN_INFO_T_SYSID_SMS_3 rebuild online parallel 8;

alter index cchlogtmp.IDX_MAIN_INFO_T_SYSID_SMS_3 rebuild online parallel 8

*

ERROR at line 1:

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

Elapsed: 00:00:00.03

21:23:15 sys@cch>alter index cchlogtmp.IDX_MAIN_INFO_T_SYSID_SMS_3 noparallel;

alter index cchlogtmp.IDX_MAIN_INFO_T_SYSID_SMS_3 noparallel

Elapsed: 00:00:00.01

21:23:15 sys@cch>spool off

21:23:15 sys@cch>exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

官方解釋：

cnsz081302:cch > oerr ora 08104

08104, 00000, "this index object %s is being online built or rebuilt"

// *Cause:  the index is being created or rebuild or waited for recovering

//          from the online (re)build

// *Action: wait the online index build or recovery to complete

cnsz081302:cch >

清理方法：

declare

isClean boolean;

object_id binary_integer;

wait_for_lock binary_integer;

begin

object_id:=837231;

wait_for_lock:=null;

isClean := sys.dbms_repair.online_index_clean();

commit;

end;

/