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: G Dahler <yellow-shark_at_spamex.com>
Date: Mon, 19 Apr 2004 16:14:42 -0400
Message-ID: <2rWgc.35035$Gp4.533722@news20.bellglobal.com>

"Clemens Keil" <clemens.keil_at_meduni-graz.at> a écrit dans le message de 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?
>

You probably have something like:

rollback_segments = (R01, R02, R...) in you initxxx.ora

You probably forgot to comment it out and only leave your actual rollback segments there.

Been there, done that ! Received on Mon Apr 19 2004 - 15:14:42 CDT

Original text of this message

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