Re: Query to re-create ini.ora

Charles Davis wrote:

> 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!
> >
> >

Nothing is truncated. You just didn't bother to set appropriate SQL*Plus settings before running your query.

Go into SQL*Plus and ... SQL> SHOW ALL

All are settable.

That said I could easily compose a SQL statement that would return an init.ora. All you need is a little concatentation with an equals sign.

I suggest that you learn some Oracle and take this on as a project.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)