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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to edit spfile ?/

Re: How to edit spfile ?/

From: Dean Paul <oracledbam_at_hotmail.com>
Date: Wed, 26 Apr 2006 15:24:41 -0400
Message-ID: <BAY117-F4948D9FC688EF6A1A7D41D3BC0@phx.gbl>


I think there is 1 line in spfile ,after changing that line we can edit spfile directly I think but I don't know . alter system and pfile are common way to edit. thx

>From: "Alex Gorbachev" <gorbyx_at_gmail.com>
>To: oracledbam_at_hotmail.com
>CC: oracle-l_at_freelists.org
>Subject: Re: How to edit spfile ?/
>Date: Wed, 26 Apr 2006 20:19:34 +0200
>
>AFAIK, only if you database is started with this spfile. Than use
>ALTER SYSTEM SET ... SCOPE=SPFILE;
>
>2006/4/26, Dean Paul <oracledbam_at_hotmail.com>:
> > Without creating pfile from spfile how can we edit spfile ?
> > thx
>
>--
>Best regards,
>Alex Gorbachev



Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 26 2006 - 14:24:41 CDT

Original text of this message

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