How do you switch from an init.ora file to a spfile?
Answer Posted / ravindra
create pfile from spfile;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is dcl? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
how to restore files with rman?
What purpose does the model database server? : sql server DBA
how can you enable flashback feature?
What is transparent data encryption? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What is fill factor? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
What is the difference between clustered and non-clustered index? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are the operating modes in which database mirroring runs? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the commands you'd issue to show the explain plan for "select * from dual"?