Home IT-Blog How to create a SPFILE from a PFILE
How to create a SPFILE from a PFILE PDF Drucken
Dienstag, 12. Dezember 2006 um 23:15 Uhr

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'; 

  

 

Kommentar schreiben


Sicherheitscode
Aktualisieren