Re: Query to re-create ini.ora

Thank you all for the help.

Unfortunately this is not what I am looking for.

The V$PARAMETER and the V$PARAMETER2 views either truncate the VALUE value (especially for many rollback segments) and a plain old select statement is not really in 'init.ora' format.

Also, the Alert_Log startup info has problems similar to the above mentioned.

I guess I was expecting a reply containing a fancy schmancy process to pull it all together, correctly syntax it all, and, voila, init.ora!!

thanks anway.

Charles

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:dYqxa.47402$MJ5.29774_at_fed1read03...
> Charles Davis wrote:
> > 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
>
> SELECT NAME || ' = ' || VALUE FROM V$PARAMETER
> WHERE ISDEFAULT = FALSE;
>
>
> HTH & YMMV
>
>
> HAND!
>
>
Received on Mon May 19 2003 - 17:26:19 CDT