ORA-08103 : Object no longer exist in database

[Adriana_andros]

Hi,
I had created a procedure named "Add_max_sal" and when I try to execute it. It occur some error during execution with this statement :"ORA-08103 : Object no longer exist in database" .it is very strange error.Why it is replying like that.Please tell me what I need to do now.

Thanks.

[Praetor]

ORA-08103 Error :

The database throws this error when some privileged user delete this particular object.As you have created before and someone have privilege to access and update on the object and get deleted by him/her.

Now you have to create a new or need to perform the recovery operation suggesting upon the database administrator.

[Katty]

ORA-08103 :Corruption error :

The object that you have created earlier and need to access now but getting some unavailability error during select command.

The reason may be the data file corruption,the tablespace is constructed through the data file but now the whole data file become corrupted with a single block where your procedure was placed.

In this case,you need to consult with Database Administrator to recover the corrupted data file.

[kelfro]

ORA-08103 :error causing Disk Unavailability:

The object that you want to access.The problem may be the disk unavailability means the disk has been completely removed on which your database object was stored.

In this case,if you have a consistent backup of your database,then you need to recover it in the guidance of database administrator. Otherwise ,you have to create it again.

[Zecho]

ORA-08103 :recovering the issues

The database administrator will perform the Incomplete recovery after this error.Using a proper backup and the archive log files would also be used to recover the appropriate database object.The procedure to recover that object :

RAMN>Restore database; /* Appropriate files would be restored from backup and archive are ready to apply */
RMAN>Recover database;