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: spfile vs pfile in 9i

Re: spfile vs pfile in 9i

From: Joel Garry <joel-garry_at_home.com>
Date: 25 Oct 2004 15:28:51 -0700
Message-ID: <91884734.0410251428.1d233338@posting.google.com>


richardpstanton_at_yahoo.com (Richard Stanton) wrote in message news:<87bc8a5f.0410120846.75eeb98e_at_posting.google.com>...
> Hello
>
> can anyone explain to me what the advantages of using spfiles are over
> the traditional pfiles? Is it just the ability to make changes to the
> database on the fly without editing files etc?

Besides all the other responses, spfile makes the RMAN DUPLICATE process a smidgen easier.

jg

--
@home.com is bogus.
No posters have been harmed in the making of this message.
Received on Mon Oct 25 2004 - 17:28:51 CDT

Original text of this message

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