How do you switch from an init.ora file to a spfile?
Answer Posted / srinivasarao
just create a spfile for pfile and then bounce the
database...While restarting, if Oracle finds spile first it
will use it first instead on pfile.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What purpose does the model database server? : sql server DBA
how can you record information about current session?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
when does an alert gets signaled?
which background process invoke at the time of upgradation tell me???
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Query processing is slow(eg select query)how will u solve that
how does an oracle clusterware manage crs resources?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What are the different sql server versions you have worked on? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Explain materialized views and how they are used.
What the different topologies in which replication can be configured? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?