Thank you, I found it.
It worked. The database is alive again.
cu
"G Dahler" <yellow-shark_at_spamex.com> schrieb im Newsbeitrag
news:2rWgc.35035$Gp4.533722_at_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:38:58 CDT
