Do You restarted server after that error? If no - don't do it, maybe
somebody will help you.
Look into alert log file to see what really happend to your DB. I think this
is the same situation I had. In Oracle 8.05.00, without installed patches,
server is not protected for exceeding 4 GB limit of file size (under NT). I
think, that database file is corrupted now and DB will not open after
restart (with error ora-1122). Database need recovery - if it works in
ARCHIVE_LOG mode this should be fast and simple (recover database or recover
datafile). Then you must create second datafile for tablespace "usr" or (i
think thats better) create another tablespace for your data.
If DB was not in ARCHIVE_LOG mode the problem is really serious. For example
I couldn't repair DB after that crash and had to restore it from backups
:-((
--
--
regards
Szymon Budys
U¿ytkownik "Pinto" <reach_me_at_india.com> napisa³ w wiadomoœci
news:9geq46$ina$1_at_news.mch.sbs.de...
> 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 Mon Jun 18 2001 - 01:28:09 CDT
