Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news-out.nuthinbutnews.com!propagator2-sterling!in.nntp.be!pd2nf1so.cg.shawcable.net!residential.shaw.ca!news1.calgary.shaw.ca.POSTED!not-for-mail X-Trace-PostClient-IP: 24.80.236.234 From: Peter Newsgroups: comp.databases.oracle.server Subject: Using the SPFILE Organization: Bright Message-ID: <7ls1evol8qll3ccthdmjru0i146ijf8b43@4ax.com> X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 14 Date: Fri, 06 Jun 2003 20:05:13 GMT NNTP-Posting-Host: 24.69.255.232 X-Complaints-To: abuse@shaw.ca X-Trace: news1.calgary.shaw.ca 1054929913 24.69.255.232 (Fri, 06 Jun 2003 14:05:13 MDT) NNTP-Posting-Date: Fri, 06 Jun 2003 14:05:13 MDT Xref: core-easynews comp.databases.oracle.server:188922 X-Received-Date: Fri, 06 Jun 2003 13:04:31 MST (news.easynews.com) When you boot up your Windows machine, Oracle would start your database instance. Oracle would use the init file in the 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