spfile Vs pfile in Oracle? File System Database
spfile - is Binary file
pfile - is txt file
location of spfile/pfile:
$ORACLE_HOME/dbs
create pfile from spfile:
create pfile from spfile;
create pfile='/tmp/initDEVDB.ora' from spfile;
create spfile from pfile:
create spfile from pfile;
create spfile from pfile='/tmp/initDEVDB.ora';
create spfile='/tmp/spfileDEVDB.ora' from pfile;
create spfile='/tmp/spfileDEVDB.ora' from pfile='/tmp/initDEVDB.ora';
startup instance only support with pfile not with spfile
startup pfile='/tmp/initDEVDB.ora';
startup spfile='/tmp/spfileDEVDB.ora';
Upcoming Batch Schedule link:
https://mallik034.blogspot.com/p/upco...
#oracledba #oraclecarrers #oracleworld #oracle #database #training #onlinetraining #liveclasses
Regards,
Mallikarjun Ramadurg
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: [email protected]