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!

select count(*) from emp, throws error "ORA-08103: object no longer exists"

NagasNov 29 2017 — edited Nov 29 2017

Hello

When i give an statement like select * from emp, i can fetch the results, but when i want to give count(*) for the same table, then i get the error "ORA-08103: object no longer exists".

Can someone explain me why this weird behaviour ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 27 2017
Added on Nov 29 2017
33 comments
1,872 views