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
how can you implement fine-grained auditing?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Why does Oracle not permit the use of PCTUSED with indexes?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What is dcl? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is replication? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how can you connect from 10g user to 11g user??
how can you create a user-defined lock?
Query processing is slow(eg select query)how will u solve that
What is the difference between dropping a database and taking a database offline? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?