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 the last version,the release date of that version and fix pack of ibm db2 udb?
What is dbcc? : sql server DBA
who owns the operating system files created by the utl_file package?
What are the different sql server versions you have worked on? : sql server DBA
What are the commands used in dcl? : sql server DBA
How do you open a cluster administrator? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
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
what are the differences of where and if in SAS?
what are the types of connection load-balancing?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how can you process messages in order asynchronously?
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
what is a crs resource?