i didnt think the info was stored in the database. I thought it was
stored as a binary file in the $ORACLE_HOME/dbs directory.
i thought the oracle startup code looked for a spfile first in the dbs
directory.
if its literally stored in the database, how is oracle able to read it
during startup?
joe
Rich Holland wrote:
> Yes, the SPFILE is stored in binary format in the database, but you can
> sort of work around it. To create a text file from the SPFILE, you can
> issue:
>
> CREATE PFILE 'pfilename' FROM SPFILE 'filename';
>
> And vice versa with:
>
> CREATE SPFILE = 'filename' FROM PFILE = 'pfilename';
>
> When starting the instance, you can also specify an alternate SPFILE:
>
> SQL> startup pfile=filename
>
> There's also some new syntax for the ALTER SYSTEM command to specify the
> scope of the change:
>
> ALTER SYSTEM set parameter = value SCOPE = MEMORY | SPFILE |
> BOTH;
>
> Rich Holland
> Guidance Technologies, Inc.
>
>
>>-----Original Message-----
>>From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of
>>dgoulet_at_vicr.com
>>Sent: Wednesday, February 13, 2002 3:43 PM
>>To: Multiple recipients of list ORACLE-L
>>Subject: Re:RE: Changing dump destinations in init.ora
>>
>>
> [...]
>
>>during the discussion on database management it was revealed that init
>>
>
>>files are on the way out, probably in 9i version 2. Their being
>>
> replaced
