问题
环境:RAC3节点 12.1.0.2 备库
实例3查询分区表报错。
oerr ora 08103
08103, 00000, "object no longer exists"
// *Cause: The object has been deleted by another user since the operation
// began, or a prior incomplete recovery restored the database to
// a point in time during the deletion of the object.
// *Action: Delete the object if this is the result of an incomplete
// recovery.
ORA-08103: Object No Longer Exists (Doc ID 1465978.1)
解决过程
询问是否有变更操作:有。
alter table x drop partiton p_x;
查看预警日志
oerr ora 01013
01013, 00000, "user requested cancel of current operation"
// *Cause:
// *Action:
查看相应trc文件中,有ORA-8103
ORA-8103故障处理
Bug 19689979 - ORA-8103 or ORA-600 [ktecgsc:kcbz_objdchk] or Wrong Results on PARTITION table after TRUNCATE in 11.2.0.4 or above (Doc ID 19689979.8)
解决方案
alter system flush shared_pool;
SQL会硬解析。