| Switch database from pfile to spfile. [message #525123] |
Thu, 29 September 2011 04:37  |
shamsh_pervaiz
Messages: 22
Registered: September 2005
Location: bangalore
|
Junior Member |
|
|
Hello Experts,
I have a database started using pfile and spfile parameter shows NULL from command prompt as below:
******************************************************************
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL>
*****************************************************************
Now when I want to change/switch database to start using SPFILE, can I do it with out restarting (shutdown and startup)the database.
Thanks in advance.
Thanks
Shamsh Pervaiz
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
