Using the SPFILE

When you boot up your Windows machine, Oracle would start your database instance. Oracle would use the init file in the <SID\>pfile directory. But what should I do so that it will automatically use the spfile in the \oracle_home\database directory?

I know "Startup open" will always the use the spfile in \oracle_home\database directory.

Assuming Oracle9i on Windows2000

Thanks Received on Fri Jun 06 2003 - 15:05:13 CDT