rebuild online时意外中断 再次重建时报错解决方法
rebuild online时意外中断
再次重建时报错
SQL> alter index PARTY.IDX_CM_INDIV_CUSTOMER_4 rebuild online;
alter index PARTY.IDX_CM_INDIV_CUSTOMER_4 rebuild online
*
ERROR at line 1:
ORA-08104: this index object 11652698 is being online built or rebuilt
DECLARE
isClean BOOLEAN;
BEGIN
isClean := DBMS_REPAIR.ONLINE_INDEX_CLEAN(11652698);
END;
/
下面是MOSC上的解释
SMON will eventually cleanup the locked index so no actions are actually needed. However, letting SMON do the cleanup can be a bit of 'hit and miss' as SMON will try to cleanup every 60 minutes
and if it cannot get a lock on the object with NOWAIT it will just try again later. In a highly active database with many transactions this can cause the rebuild to take a long time as SMON won't get
the lock with NOWAIT. Other cases like uncommitted transactions
against the table will also result in SMON not rebuilding the index.
As long as the index is not rebuild all access to the index will result in ORA-8104 or ORA-8106. So to solve this situation a manual cleanup can be done using the new function
DBMS_REPAIR.ONLINE_INDEX_CLEAN()
SQL> conn / as sysdba
SQL> DECLARE
isClean BOOLEAN;
BEGIN
isClean := DBMS_REPAIR.ONLINE_INDEX_CLEAN();
END;
/
The function is fully documented in the manual: PL/SQL Packages and Types Reference, 10.2
最新文章
- SQLite3中自增主键归零方法
- BaiduTemplate模板引擎使用示例附源码
- 经典功率谱估计及Matlab仿真
- 使用CSS3对链接颜色与下划线进行优化
- 找到MVC框架中前端URL与后端同步的解决方案
- poj1470 LCA Tarjan
- 数据库MySql阶段总结
- Python入门基础教程(儿童版) [分享一本入门级教程]
- VS2010中<无法打开包括文件:“iostream.h”:>错误解决方法
- Arpa's weak amphitheater and Mehrdad's valuable Hoses
- Oracle Sql优化之Merge 改写优化Update
- js原生继承之——构造函数式继承实例
- 实现excel导入导出功能，excel导入数据到页面中，页面数据导出生成excel文件
- jfinal编码问题及解决
- java版的类似飞秋的局域网在线聊天项目
- obj-c中如何定义类的私有实例方法
- Markdown初入门(使用Typora编辑)
- 《图解HTTP》读书笔记（三：无状态协议/cookie管理状态）
- Java常用的九种排序方法及代码实现
- Linux集群之keepalive+Nginx