Fulltext results:

Oracle: SPFile and PFiles

4 Hits, Last modified: 12 years ago

om "PFiles", which are regular text files. ===== Create PFile ===== To export the SPFiles to a PFile, just enter the following in SQLplus: <code sql> CREATE PFILE FROM SPFILE; </code> It will create a PFile ''${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora''. ===== I... MEDIATE; STARTUP NOMOUNT PFILE='${PATH_TO_PFILE}' CREATE SPFILE FROM PFILE; SHUTDOWN IMMEDIATE; </code> I

Oracle: Resize Instance

1 Hits, Last modified: 12 years ago

onally) export the SPFile to a PFile: <code sql> CREATE PFILE FROM SPFILE; </code> Finally, reboot the i