Re: object no longer exists!!!!

Hi Pinto,

If this is the case you can add a datafile to the tablespace with the ALTER TABLESPACE command..

Hth,

Steve

Pinto wrote:

> Hello,
> i was checking the tablespace size and this is what i found. i guess this is
> the problem.
>
> the user tablepspace has auto extend set to true, max size is unlimited and
> max block is unlimited.
> and the usr tablespace size is 4081.44 MB and is 98.7% used.
>
> temporary tablespace is 178.76 mb in size and is 100% used.
>
> so why didn't the auto extend work, is there a filesize limit of 4 GB or
> something. the configuration is oracle 8.0.5 on win NT. there is plenty of
> free space available on the harddisk.
>
> what is the solution now. i am just a developer with limited DBA knowledge.
> thanks in advance.
> 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 Fri Jun 15 2001 - 08:21:27 CDT