Re: How to detect missing rollback segments?

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 26 Sep 1999 16:55:06 GMT
Message-ID: <7slj5a$sjr$2@news.seed.net.tw>

Erwin Dondorp <erwindon_at_wxs.nl> wrote in message news:37ED0055.DCA1D21C_at_wxs.nl...
> Hi,
>
> Does anyone know the answer to this question?:
> An Oracle database will not start when invalid rollback statements are
> specified in the init-file.
> How can I detect that this will happen *before* I open the database?
> Is there any query I can do on the fixed tables while the database is
> only mounted (and not opened) to know this in advance?

It's no need to detect, and you can'd detect, before the database is open. Just remove or remark the line "rollback_segments" in init.ora, startup, identify the rollback segments, edit init.ora, then restartup. Received on Sun Sep 26 1999 - 11:55:06 CDT