Re: Deleting a rollback segment
Date: Wed, 25 Apr 2001 14:38:03 +0200
Message-ID: <9c6ggn$csle$1_at_as121.tel.hr>
Maybe you can drop that rollback segment, and let that software of yours create it again
ALTER ROLLBACK SEGMENT xxx OFFLINE;
DROP ROLLBACK SEGMENT xxx;
Note: you cannot drop SYSTEM rollback segment
Dado
"Ernesto" <ernesto.moreno_at_POR_FAVOR_NO_SPAM_katamail.com> wrote in message
news:3ae68ba0.697177087_at_news.sarenet.es...
> Hi!
>
> I've installed an Oracle instance, but a 3rd party
> software manages it, and creates a DataBase.
>
> When installing the DataBase, an O/S error happened,
> and when re-starting again, I get this message:
> "ORA-01535: rollback segment XXX already exists."
>
> I suppose that this 3rd party software has created the
> rollback segment before O/S crashed.
>
> Anybody knows how to solve this?
>
> Thankx.
> ==========
> MIRELLO
Received on Wed Apr 25 2001 - 14:38:03 CEST