SQL Error 8103 while data loading

[Former Member]

Hi all,

We were loading data to a cube by an IP during which we faced an error. For that moment , the old request was deleted from target and step was repeated and chain got completed successfully. But I want to know why did error happened ? I was unable to get much information regarding this issue.

Error Messages ::

1) SQL Error:8103

2) Errors in source system

3) ORA-08103 : object no longer exists

I also looked into sm21 and found " Database error 8103 at FET" . Main points I want to know about this are ::

1) why this error occured ?

2) what is proper solution for the same ?

Regards,

Arpit

[Former Member · Accepted solution]

Check Note No. 1144558, This error came during reorganisine the table space.

Regards,

Sushant

[lbreddemann]

Hello Arpit,

besides the already mentioned possible reasons, you will want to make sure that your Oracle database is on the most current SAP Bundle Patch and that the parameters are set correctly.

Given that, the error shouldn't reoccur.

regards,

Lars

[Former Member]

Hi Arpit,

For the error ORA-08103: object no longer exists, find the below details for cause and solution.

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 and Remove references to the object.

Also check the below link..

http://www.dba-oracle.com/t_ora_08103_object_no_longer_exists.htm

Regards,

NIKHIL