ORA-08103: object no longer exists
Hi,
I am facing to a problem that the database return error ORA-08103 while query table.
Query 1:
select count(*)
from charge c
where c.charge_date BETWEEN to_date('25-11-2018 00:00:00','dd-mm-yyyy hh24:mi:ss') AND to_date('26-11-2018 23:59:59','dd-mm-yyyy hh24:mi:ss')
and c.account_id IN ('3000185586','3000185598','3000185606');
Plan hash value: 1297822814
-------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop |
-------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 13 | 6263 (1)| 00:00:01 | | |
| 1 | SORT AGGREGATE | | 1 | 13 | | | | |
| 2 | PARTITION RANGE MULTI-COLUMN | | 1 | 13 | 6263 (1)| 00:00:01 |KEY(MC)|KEY(MC)|
| 3 | INLIST ITERATOR | | | | | | | |
|* 4 | TABLE ACCESS BY LOCAL INDEX ROWID| CHARGE | 1 | 13 | 6263 (1)| 00:00:01 |KEY(MC)|KEY(MC)|
|* 5 | INDEX RANGE SCAN | I_CHARGE_ACCOUNT | 85 | | 5902 (1)| 00:00:01 |KEY(MC)|KEY(MC)|