Interested to Buy Any Domain ? << Click Here >> for more details...
How do you switch from an init.ora file to a spfile?
- 4 Answers
- 19724 Views
- TCS, I also Faced
- E-Mail Answers
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 is the importance of a recovery model? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
which background process invoke at the time of upgradation tell me???
how can you get actual data change values from previous transactions in oracle?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
how can a session indicate its interest in receiving alerts?
Where do you find the default index fill factor and how to change it? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What the different topologies in which replication can be configured? : 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
