Re: object no longer exists!!!!

Though I haven't really got a clue, I would suggest looking at your free space in tablespaces and so on.
Oracle tends to produce some illogical error messages.

>> select * from tab

I suppose you mean a select * from user_tables?

regards,
Patrick Sinke

Pinto <reach_me_at_india.com> schreef in berichtnieuws 9gcbfd$t15$1_at_news.mch.sbs.de...
> Hello all,
> i am facing a very strange problem.
> when i do a select from any table i am getting this error message,
>
> SQLWKS> select * from eb_bcp_job_user
> JOB_INT_ID USER_ID
> ---------------------------------------- ------------------------------
> ORA-08103: object no longer exists
>
> but select * from tab, lists all the table. what do you think has gone
> wrong.
> basically i was running a database intensive procedure, which contantly
> updates a log table and while the procedure was running, i just queried
 the
> log table and this happened.
>
> any help greatly appreciated,
> many thanks in advance.
> Pinto.
>
>
>
>
>
>
Received on Fri Jun 15 2001 - 03:05:12 CDT