Re: How to edit spfile ?/

  • From: "Dean Paul" <oracledbam@xxxxxxxxxxx>
  • To: gorbyx@xxxxxxxxx
  • Date: Wed, 26 Apr 2006 15:24:41 -0400

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@xxxxxxxxx>
To: oracledbam@xxxxxxxxxxx
CC: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx>:
> 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/

--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2006