Home IT-Blog How to create a SPFILE from a PFILE
How to create a SPFILE from a PFILE PDF Print
Tuesday, 12 December 2006 23:15

Migrating from a pfile to a spfile is really simple. You can use the following command on the console:

CREATE SPFILE FROM PFILE = 'C:\oradata\mydb\init.ora' 

... of course you have to enter the right path to the init.ora file... Wink

To do it the other way is also possible, just type

CREATE PFILE = 'C:\oradata\mydb\init.ora' FROM SPFILE = 'C:\oradata\mydb\spfilemydb.ORA'; 

  

 

Add comment


Security code
Refresh