Skip to Content
avatar image
Former Member

ORA-08103 : object no longer exists

Hello all,

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Mar 04, 2008 at 09:21 AM

    Hello Salim,

    please take a look at this one:

    - http://ora-08103.ora-code.com/

    Or you maybe hitting the 2GB+ problem... what operating system are you using and what is the limit?

    For checking your oracle ddic take a look at metalink-note #136697.1

    For the 2GB+ problem take a look at here:

    - http://djiang.wordpress.com/2006/07/25/ora-08103/

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Stefan Koehler

      Hello back,

      The said index and table is not partitioned.

      i have run the query,

      SQL> SELECT PARTITION_NAME, STATUS from ALL_IND_PARTITIONS WHERE INDEX_NAME = '/BIC/B0000223000~0';

      no rows selected