Re: Creating PFILE from SPFILE with *.

From: Dave <x_at_x.com>
Date: Tue, 01 Mar 2005 20:53:28 GMT
Message-ID: <cD4Vd.26436$8B3.1761@text.news.blueyonder.co.uk>

"HARI OM" <hari_om_at_hotmail.com> wrote in message news:1109708251.720484.323360_at_o13g2000cwo.googlegroups.com...
> Thanks Dave.
>
> But I am NOT using any RAC or such things...
>
> When I log in to SQLPLUS and execute "show parameter spfile" it shows:
>
> ------------------------------------------------------------------------------
>
> NAME TYPE VALUE
> ------------------------------------------------------------------------------
>
> spfile string ?/dbs/spfile@.ora
>
>
> but there is NO SUCH file on the system....infact there is no such
> directory as ?/
>
>
> Any hints?
>

? is an alias for $ORACLE_HOME so its in $ORACLE_HOME/dbs the @ is an alias for the ORACLE_SID

time to read those manuals I think Received on Tue Mar 01 2005 - 14:53:28 CST