ORA-08103 object no longer exist

[waela]

I have a problem with one of the tables in the database when I try to select from that table any record I got the following message
"ORA-08103 object no longer exist"

please try to help me gentlemen
the matter is very critical
parak allah feekom
salamu3alaikom

[h_elshawaf]

السلام عليكم ورحمة الله وبركاته
be sure that u connect with user that have these tables or use prefix name like (user_name.table_name) if u connect with the user that have privilege to select from these tables

i think this is the problem
ادرى بأن هناك فجرا .. وبأن بعد العسر يسرا
لكنهم ساموا الفتى وبلاده عسفا وقهرا
والعالم الحيران يشهد ما يحل بأمتى
وأنا هنا فى غربتى فى لوعتى ابكى وامسح فى ذهول دمعتى
واظل انظر للسماء والقلب يخفق بالدعاء
يارب أوقظ امتى

[khaled]

make sure that the table you try the display its information is exist in yor user by using this command
Sql> desc <table name>
or you have a permision to access to this object form other user

[waela]

I have made what you recommended to be sure but no use because I can access or select from other tables in the same schema.
what you recommend?

thank you for your cooperation .
also if anyone have any tools to recover or repair the tables it would be appreciated.

regards;

[msh]

السلام عليكم ورحمة الله وبركاته،،
أخي هل الجداول من النوع global temporary tables أقصد أنها قد تكون جداول مؤقتة تحتفظ بالبيانات وقت transaction وعند أنتهاء ال transaction يتم حذفها ! تأكد من هذا الموضوع وإذا كانت كذلك يمكنك الرجوع إلى هذه الروابط :
Oracle base
orsweb
مع تحياتي