How do we switch from init.ora file to asp file?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How to use "if" statements on multiple conditions?
What is the difference between "as" and "is" in an oracle stored procedure?
How to use subqueries in the from clause in oracle?
What is difference between Rename and Alias?
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
Explain can a view based on another view?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is data block in Oracle?
How can I see all tables in oracle?
What are the limitations oracle database 10g xe?
In what script is snap$ created? In what script is the scott/tiger schema created?