Re: spfile vs pfile in 9i

From: Richard Stanton <richardpstanton_at_yahoo.com>
Date: 14 Oct 2004 00:42:02 -0700
Message-ID: <87bc8a5f.0410132342.64e5a5bf@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?
>
> 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

Thanks for your replies

Richard Received on Thu Oct 14 2004 - 02:42:02 CDT