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: 10G - editing SPFILE

Re: 10G - editing SPFILE

From: zeb <spam_at_nowhere.com>
Date: Wed, 20 Oct 2004 21:28:11 +0200
Message-ID: <4176bb8a$0$286$636a15ce@news.free.fr>


>
> and I can't edit the SPFILE manually as Oracle won't start complaining
> it's corrupt or something.
>

In 10g, even if the database is not started , you can do:
> create pfile from spfile;

So you can get a pfile to edit
You startup with it if you rename the old spfile

HTH Received on Wed Oct 20 2004 - 14:28:11 CDT

Original text of this message

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