How do you switch from an init.ora file to a spfile?
Answer Posted / santo
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 ? | 28 Yes | 1 No |
Post New Answer View All Answers
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the default fill factor value? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
internal architecture
What are the different types of indexes available in sql server? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is a crs resource?
What types of replication are supported in sql server? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Which autogrowth database setting is good? : sql server DBA
what is the role of dip user in our database?
Why would you use sql agent? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?