Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback Segment

Re: Rollback Segment

From: Clemens Keil <clemens.keil_at_meduni-graz.at>
Date: Mon, 19 Apr 2004 22:44:01 +0200
Message-ID: <c6190e$25q$1@skirner.kfunigraz.ac.at>


Hi DJ,
wanted to thank you personally for taking care of this, but coud not reach you. (DNS-server seems not to exist). You can find below another entry. Maybe you deal with that either.
Thanx.

"DJ" <nospamplease_at_goaway.com> schrieb im Newsbeitrag news:pqWgc.208$C24.178_at_newsfe1-win...
>
> "Clemens Keil" <clemens.keil_at_meduni-graz.at> wrote in message
> news:c615m0$1vq$1_at_skirner.kfunigraz.ac.at...
> > Hello All,
> > I have an Oracle 8i Database. Within the Datafile where I have had 10
> > Rollback-Segments I have taken one offline and have deleted it to save
> disk
> > space. Now it seems that I cannot mount the database any more. I can
> connect
> > in the svrmgr30-console but when I want to startup the database I get
the
> > message
> > "database mounted." and in the next line
> > "ORA-01534: rollback segment 'RB2' does not exist"
> >
> > And I do not get any access to the db neither through EnterpriseManager,
> > StorageManager nor through SQL-Worksheet.
> >
> > Any idea?
> >
> >
>
> well deleteing the rbs wont save space
>
> however.... find your init.ora file and remove rb2 from it in the rollback
> segments section
>
>
Received on Mon Apr 19 2004 - 15:44:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US