we can switch from init.ora file to a sp file with the help of the command

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

Question Posted / sachin

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

Please Help Members By Posting Answers For Below Questions

Explain the use of show option in imp command.

1098

How to insert multiple rows with one insert statement in oracle?

1087

What are the extensions used by oracle reports?

1037

How to create a single index for multiple columns?

1037

In the oracle version 9.3.0.5.0, what does each number shows?

1301

Is the After report trigger fired if the report execution fails ?

2915

How to use select statement to count the number of rows in oracle?

1046

What is set verify off in oracle?

1106

How remove data files before opening a database?

1074

How to create a table interactively?

1093

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2234

What is the difference between translate and replace in oracle?

1165

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

How to convert numbers to characters in oracle?

1030

What is meant by joins?

1062