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 the indexes are stored in the Oracle Database?

1954


How to define a data source name (dsn) in odbc manager?

754


What privilege is needed for a user to query tables in another schema?

730


How to convert a string to a date in oracle database?

778


What is the relation of a user account and a schema?

864


How to best split csv strings in oracle 9i?

791


How to define a procedure inside another procedure?

751


How do we display rows from the table without duplicates?

720


What do you mean by group by clause?

771


Explain the dml?

765


What is data block in Oracle?

836


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2010


What is meant by an index?

804


What is the best way to do multi-row insert in oracle?

800


Describe varray?

833