Sunday, 7 May 2017

Easy Way to Create pfile from spfile

During the search in online I learned something new today; you can create pfile from spfile simple way .

create pfile=’/tmp/init@.ora’ from spfile;

The @ automatically substitute SID.

SQL> create pfile='/tmp/init@.ora' from spfile;

File created.

Now Check That pfile created with SID or not

ls –ltrh /tmp

-rw-r--r--  1 oracle    oinstall  1.6K May  7 09:53 initSUNIL.ora

No comments:

Post a Comment