Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 9i Newbie : spfile, sql-backtrack questions
> However I still continue to use my init.ora files.
> Where does spfile come in the picture ? I do not have it right now.
> I am misiing something . Can some help? Do i need to
> create my spfile once I upgraded the DB ? Will my init files continue to work ?
You don't need to create a spfile. Oracle will also start with an init.ora file (as it does right now). The advantage of a spfile is that you can dynamically alter your system parameters and Oracle will write your changes to the spfile (at your will) so that they survive the next restart of your instance. There is a CREATE SPFILE command to create the initial spfile from your init.ora file. Refer to Oracle 9i doc for further information.
Regards,
Knut
-- Dipl.-Inform. Knut Talman Fon +49.30.72 62 01 411 myToys.de GmbH Fax +49.30.72 62 01 222 Schoenhauser Allee 36-39 Mobil +49.173.671 65 65 D-10435 BerlinReceived on Thu Apr 11 2002 - 13:07:10 CDT