Kirti, that's what "strings" command is for.
strings spfile>/tmp/init.ora and you're good to
go.
On 02/18/2004 09:39:51 PM, Kirtikumar Deshpande wrote:
> On UNIX
>
> grep '^*' spfileSID.ora > initSID.ora
>
> will also get you going...
>
>
> - Kirti
>
>
> --- Jonathan Gennick <jonathan_at_gennick.com> wrote:
> > Wednesday, February 18, 2004, 8:27:34 PM, Adam Donahue (adonahue_at_opsware.com) wrote:
> > AD> Are you sure about that?
> >
> > I thought I was sure, but it turns out I didn't test
> > carefully enough. Shame on me.
> >
> > AD> I just tested this on a couple local instances, and was
> > AD> able to create both a pfile from spfile, and spfile from
> > AD> pfile, on an idle instance.
> >
> > Sure enough. I was wrong. It can be done:
> >
> > SQL> connect system/sql8plus4 as sysdba;
> > Connected to an idle instance.
> > SQL> create pfile='c:\a\init.ora' from spfile='c:\oracle\ora10\database\SPFILEOR
> > CL.ORA'
> > 2 ;
> >
> > File created.
> >
> > Knowing this, it now seems possible to recover from a
> > screwup without having to bother making backups each time I
> > change a parameter.
> >
> > Life is good again.
> >
> > Best regards,
> >
> > Jonathan Gennick --- Brighten the corner where you are
> > http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com
> >
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail SpamGuard - Read only the mail you want.
> http://antispam.yahoo.com/tools
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
--
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Feb 18 2004 - 20:52:58 CST
