ORA-08103

problem

Environmental Science ：RAC3 node 12.1.0.2 For the library

example 3 Query partition report error .

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)

To solve the process

Ask if there is any change operation ： Yes .
alter table x drop partiton p_x;

Check the alert log

oerr ora 01013
01013, 00000, "user requested cancel of current operation"
// *Cause:
// *Action:

Check out the corresponding trc In file , Yes ORA-8103
ORA-8103 Fault handling

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)

Solution

alter system flush shared_pool;

SQL Hard parsing .

Use with caution