SPFILE is teh first option that oracle will consider before looking for the
PFILE.
ur SPFILE should be at $ORACLE_HOME/dbs directory.
--
HTH
Regards,
Ganesh R
"Peter" <peter_at_nomorenewsspammin.ca> wrote in message
news:gr3kbv84qsekkkbidi30tmnvlbpeptf447_at_4ax.com...
>
> Suppose you have a spfile in oracle_home\database.
> How do you force Oracle to use this spfile on startup instead of the
> init file (assuming you have another init file in \<SID>\pfile)?
> Using a SPFILE= line to redirect from the init file is not the same as
> having Oracle using the spfile directly?
>
> Thanks
>
>
>
>
Received on Wed Jun 11 2003 - 08:19:17 CDT
