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