Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-08103: object no longer exists

4joey1Feb 16 2011 — edited Feb 17 2011
Hallo!I am getting this error when I do a simple select statement in Oracle 10g

select * from employees;

ERROR at line 1:
ORA-08103: object no longer exists

Yet when I use the where clause,I am able to generate output.for example,the following statement generates output

select * from employees where employee_id=100;

How can this be so?

Please assist.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2011
Added on Feb 16 2011
10 comments
1,844 views