| spfile [message #167797] |
Mon, 17 April 2006 03:11  |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
hello
i noticed that oracle 9i on windows xp locate the spfile always in \oracle_home\database
how can i change this preference?
i know that i can specify a pfile on startup
like sql> startup pfile=c:\pfile
but how to change the spfile location ?
thanks
|
|
|
|
|
|
| spfile [message #167839 is a reply to message #167797] |
Mon, 17 April 2006 07:58  |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
i did so
but i still looking for the spfile under the same old location ora_home\database\
?
help thanks
|
|
|
|
| Re: spfile [message #167853 is a reply to message #167839] |
Mon, 17 April 2006 08:52 |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
create a pfile with the line
spfile='location of spfile'
then start the instance pointing to the pfile:
startup pfile='location of your pfile'
However, you must bear in mind that the spfile must still reside on the server itself (even tho' not necessarily in the default location)
HTH
Jim
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
