Re: Rollback Segment

From: DJ <nospamplease_at_goaway.com>
Date: Mon, 19 Apr 2004 21:13:54 +0100
Message-ID: <pqWgc.208$C24.178@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:13:54 CDT