Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query to re-create ini.ora

Re: Query to re-create ini.ora

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 17 May 2003 06:39:20 -0700
Message-ID: <dYqxa.47402$MJ5.29774@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 Sat May 17 2003 - 08:39:20 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US