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 is a user-defined lock?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What purpose does the model database server? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are the commands used in dcl? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
How to start SQL Server in minimal configuration mode?
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 you process messages in order asynchronously?
Query processing is slow(eg select query)how will u solve that
how can you initialize log miner?
what do you understand by flashback feature of oracle?
What is the default port no on which sql server listens? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA