How do we switch from init.ora file to asp file?

Answer Posted / sachin

we can switch from init.ora file to a sp file with the help
of the command
create spfile from
pfile='c:\oracle\database_name\pfile\init.ora'

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In which language oracle has been developed?

646


What is an oracle table?

556


What will be the syntax to find current date and time in format "yyyy-mm-dd"?

568


What is a dynamic performance view in oracle?

607


What to do if dba lost the system password?

597






What is Reduced List of Values?

1704


What is oracle database client?

553


Explain the use of rows option in imp command.

604


How to drop an existing table in oracle?

592


What is PL/SQL ?

1114


Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

643


What is hash cluster in oracle?

595


Explain rename?

552


What is where clause in oracle?

529


What are the extensions used by oracle reports?

571