Minion Skywalker Minion Skywalker - 2 months ago 5x
SQL Question

Oracle: How to create spfile.ora?

I red what Oracle 9i have spfile.ora default , but i don't understand : why that file isn't in Oracle 9i as default. Because: how to create spfile.ora correctly in Oracle 11g ?


You must be connected to your Oracle 9i instance as SYS. Then use the following to create your spfile

CREATE SPFILE='/u01/oracle/dbs/spfile.ora'
FROM PFILE='/u01/oracle/dbs/init.ora';