ORA-08103 : object no longer exists
When BW team try to do extraction they hit error Database error text........: "ORA-08103: object no longer exists"
it occurs at table /BIC/B0000223000.
I suspect there they might be oracle block corruption as i have referred to notes Note 365481 - Block corruptions.
From Oracle, when we try to describe the table, it can display the table, but when i try to select count(*) from "/BIC/B0000223000" it prompted "ORA-08103: object no longer exists"
After referring to notes Note 23345 - Consistency check of ORACLE database, i try to run the analyze table "/BIC/B0000223000" validate structure cascade; but still it gave the same error which is "ORA-08103: object no longer exists".
After that, i try to select the index for the table, select index_name from dba_indexes where table_name = '/BIC/B0000223000', it prompted that no rows selected, meaning that the index already missing.
so, after reviewing the solution provided by notes 365481, they advise to do the index reorganization. Is it relevant for us to do the index reorganization? because the index does not exist.. Is there any suggestion or experienced the same problem? thank you.