问题描述如下:
ONLINE参数建立INDEX:
CREATE INDEX IDX_ON_PP_cpe ON PP
(CELLNUM, PRODSN, EXPECTDATE)
NOLOGGING
TABLESPACE PP_IDX onlinE;
由于PP表的数据量大概有3000多万,执行到一半的时候由于网络问题,内网跟外网断开,导致这个建立索引的操作终止,现在查看这个PP表的INDEX,已经有这个索引存在,想rebuild这个索引,但是报如下错误:
sqlplus >alter index IDX_ON_PP_cpe rebuild;
ORA-08104 this index object 7732 is being online built or rebuilt
sqlplus >drop index IDX_ON_PP_cpe;
ORA-08104 this index object 7732 is being online built or rebuilt
ORA-08104 错误描述如下:
ORA-08104 this index object string 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.
OS:SOLARIS 8
DB:9206
搜索帖子发现坛子里有人也遇到过这个问题,最后是怎么解决的?
ONLINE参数建立INDEX:
CREATE INDEX IDX_ON_PP_cpe ON PP
(CELLNUM, PRODSN, EXPECTDATE)
NOLOGGING
TABLESPACE PP_IDX onlinE;
由于PP表的数据量大概有3000多万,执行到一半的时候由于网络问题,内网跟外网断开,导致这个建立索引的操作终止,现在查看这个PP表的INDEX,已经有这个索引存在,想rebuild这个索引,但是报如下错误:
sqlplus >alter index IDX_ON_PP_cpe rebuild;
ORA-08104 this index object 7732 is being online built or rebuilt
sqlplus >drop index IDX_ON_PP_cpe;
ORA-08104 this index object 7732 is being online built or rebuilt
ORA-08104 错误描述如下:
ORA-08104 this index object string 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.
OS:SOLARIS 8
DB:9206
搜索帖子发现坛子里有人也遇到过这个问题,最后是怎么解决的?
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28419/viewspace-613761/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
mts连接的问题
请登录后发表评论
登录
全部评论
