Re: alter system reset

Arup Bhai, many many thanx for your explanation.

Regards,
Prem Khanna J.

02-09-2003 12:19:25, "Arup Nanda" <orarup_at_hotmail.com> wrote:

>Prem,
>
>The SPFILE should never be opened to be modified; opening a file to see the
>contents are acceptable and that's what I said. Sometimes opening the file
>in an editor may not be needed;
>"type" in Windows command prompt or "cat" in unix will let us achive the
>same objective.
>
>Talking about the SPFILE modification, you can't effectively modify it with
>accuracy. The file is binary (actually binary in the beginning and then text
>towards the bottom part), so even if you open it in notepad and save it,
>there is no guarantee that the file will be accurately saved with all
>contents intact.
>
>By the way, I have edited the SPFILE in some cases, only in development,
>though; but I wouldn't advise it to be done that way; always use ALTER
>SYSTEM ... SCOPE=SPFILE to modify it or edit the init.ora file and then
>create the SPFILE from it. You can create the spfile from pfile even when
>the instance is down.

>HTH.
>Arup

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).