Re: object no longer exists!!!!

there are no other users except for sys,system and dbsnmp other then this user.

i can provide you with some more details,

usr tablespace
used 98.7%
size 4081.44 MB
free 52.99 MB
blocks 522424
autoextend TRUE
next extent 8 KB
max size unlimited
max blocks UNLIMITED
status available

fragmentation

#Empty blocks 6783
#pieces 21
largest 795
smallest 10
average 323
#usable peices 0

RBS tablespace
used 100%
size 215 MB
used 215 MB
FREE 0 MB
blocks 27521
autoextend TRUE
NEXT extent 8KB
max size UNLIMITED
Max blocks UNLIMITED

can this give you any hints.

regards,
Pinto.

Pinto <reach_me_at_india.com> wrote in message news:9gd437$co7$1_at_news.mch.sbs.de...
> hello steve,
> will adding datafile to the tablespace bring back all the data.????
> regards,
> pinto.
>
>
> Pinto <reach_me_at_india.com> wrote in message
> news: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 Sat Jun 16 2001 - 00:14:03 CDT