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

List out the components of logical database structure of oracle database.

983

How to add a new column to an existing table with a default value?

964

WHAT IS ecc 6.0

2101

What are the ansi data types supported in oracle?

894

What are the arithmetic operations?

1023

Explain the use of online redo log files in oracle.

991

How to write date and time interval literals in oracle?

971

What is snapshot is too old? Give and example for better understand.

1543

How to get last row id?

938

What is a user account in oracle?

1064

What is the difference between substr & instr functions?

1119

List the types of joins used in writing subqueries?

941

How to drop an index?

907

How many types of segments in Oracle?

1011

How to connect to the server with user account: sys?

968