Re: Query to re-create ini.ora

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sun, 18 May 2003 08:18:08 +1000
Message-ID: <Knyxa.36878$1s1.526361@newsfeeds.bigpond.com>

"Charles Davis" <cdavis10717_at_comcast.net> wrote in message news:d4ycncHO1tg0pVujXTWcpw_at_comcast.com...
> Hi, all!
>
> Does anyone have a query that can essentially "re-create" the init.ora
file
> showing only the originally specified parm values and exclude default
parms?
>
> Thanks.
>
> Charles

Yup: it's called the Alert Log. Every time you startup, all the parameters which are set to non-default values are included in it. You just cut and paste, and you have exactly what you're after.

Regards
HJR Received on Sat May 17 2003 - 17:18:08 CDT