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

how can we store any pdf file in oracle

1853


What is oracle database 10g express edition?

803


What is java oracle used for?

766


What are the various oracle database objects?

869


how the indexes are stored in the Oracle Database?

1954


How to initialize variables with default values?

856


please explain.. DB architecture ...

1761


How to convert raw data type into text in oracle? Explain

787


What is the use of file param in imp command?

881


How to drop an existing table in oracle?

804


How can we force the database to use the user specified rollback segment?

817


What is oracle rownum?

691


What happens in oracle commit?

760


How can we create the complete backup of data in the oracle.

1897


can anyody please send me the dump for Oracle 10g certifications for DBA path?

1912