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
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
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 is the default port no on which sql server listens? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What are the different ways you can create databases in sql server? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Where would you look for errors from the database engine?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
how can you record information about current session?
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?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.