ORA-08103: object no longer exists#

[Former Member]

HI ,

We are getting an run time error while trying to open Some PO. Error is...

DBIF_RSQL_SQL_ERROR

SQL error 8103 occurred when accessing table "EKBZ ".

Database error text........: "ORA-08103: object no longer exists#"

Internal call code.........: "[RSQL/FTCH/EKBZ ]"

"DBIF_RSQL_SQL_ERROR"

"SAPLME08 " or "LME08U02 "

"MMPUR_EKBZ_READ_EBELN_EBELP"

Our Stack in Oracle 10.2.0.2 SAP 4.6c Windows.

Please let me know if you need further logs etc.

Thanks

Raj

[former_member204080]

Hi,

Please go through these

1559652 - How to deal with block corruptions on Oracle

[Former Member]

Hi Yograj,

It seems that a data block that belong to the EBKZ table has been corrupted. Check the table structure by the statement, below;

analyze table <table_name> validate structure;

This is one of the possiblity. That may be an Oracle bug, also. You can check the document, below on the Oracle metalink, for the further information;

OERR: ORA-8103 "object no longer exists" / Troubleshooting, Diagnostic and Solution [ID 8103.1]

Best regards,

Orkun Gedik