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 is it different from a normal table?

582


What is the difference between substr & instr functions?

597


How to create a single index for multiple columns?

560


What is meant by joins?

621


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1438






What is hot backup and logical backup?

608


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1504


Can we save images in a database and if yes, how?

592


Please explain oracle data types with examples?

588


What is a read only transaction in oracle?

596


Which is better Oracle or MS SQL? Why?

3974


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

507


Hi Can any one tell me what are the API's used in requisition import.

1485


How to connect to a remote server?

557


How to create a new tablespace in oracle?

560