Re: SPFILE

From: gazzag <gareth_at_jamms.org>
Date: Thu, 14 Aug 2008 03:15:48 -0700 (PDT)
Message-ID: <47ecd3dd-3751-4cda-b474-7a2f2336cbe4@t54g2000hsg.googlegroups.com>


On 12 Aug, 18:13, Mtek <m..._at_mtekusa.com> wrote:
> Hi,
>
> We are not using SPFILE now.  But we have decided to.  One the file is
> created, do we need to restart the instance for it to take effect, so
> then we can use ALTER SYSTEM to change parameters?  Or once we create
> it, is it automatically active?
>
> Thanks.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#sthref428

HTH -g Received on Thu Aug 14 2008 - 05:15:48 CDT

Original text of this message