Some days before I have got big problem with Oracle and all started with the
same information - object no longer exists (datafile has been corrupted
after unsucessful resizing operation (Oracle v. 8.0.5.00)) :-(((
--
--
regards
Szymon Budys
U¿ytkownik "Patrick Sinke" <patrick.sinke_at_cgey.nl> napisa³ w wiadomoœci
news:992594417.452014_at_sleeper.capgemini.nl...
> 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 - 06:43:04 CDT
