Re: spfile vs pfile in 9i

"Richard Stanton" <richardpstanton_at_yahoo.com> 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?
>
> Also, why are there so many pfiles created for each database in 9i,
> and what do they all do?
>
> I have a test database and the following pfiles have been created for
> it:
>
> oracle\ora92\database\inittest.ora
> oracle\ora92\sysman\ifiles\def_TEST.domain.co.UK.ora
> oracle\admin\test\pfile\init.ora
>
> and this spfile:
>
> oracle\ora92\database\spfiletest.ora
>
> thanks for your help
>
> Richard

spfile is required for Dataguard use (if you ever planned to use DG) Received on Wed Oct 13 2004 - 08:01:00 CDT