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

What are dml statements in oracle?

1089

how to handle exceptions in post production

1414

What is the quickest way to export a table to a flat file?

960

Why do we use bulk collect in oracle?

1056

Describe varray?

1052

How to select an oracle system id (sid)?

1058

What is query image?

977

What is execute immediate in oracle?

1011

How to specify default values in insert statement using oracle?

1096

How can I combine multiple rows into a comma-delimited list in oracle?

1052

What are the differences between blob and clob in oracle?

1080

What are triggers in oracle?

1027

What is difference between cartesian join and cross join?

1081

Explain an integrity constrains?

1137

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

1028