spfile Vs pfile in Oracle? File System Database
Автор: Vismo Technologies
Загружено: 2024-02-06
Просмотров: 2275
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: mallikarjun.ramadurg@gmail.com
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
