Home » Unlabelled » How can you covert SPFILE to PFILE and PFILE to SPFILE? | Oracle DBA
Sunday, 22 April 2012
How can you covert SPFILE to PFILE and PFILE to SPFILE? | Oracle DBA
One can easily migrate from a PFILE to SPFILE or vice versa. Execute the following commands from a user with the SYSDBA or SYSOPER privilege: SQL> CREATE PFILE FROM SPFILE; SQL> CREATE SPFILE FROM PFILE;
No comments:
Post a Comment