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
How do you open a cluster administrator? : sql server DBA
how can a session indicate its interest in receiving alerts?
what do you understand by fine-grained auditing?
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.
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?
What are the commands you'd issue to show the explain plan for "select * from dual"?
who owns the operating system files created by the utl_file package?
internal architecture
what functionality does oracle provide to secure sensitive information?
What is the default port no on which sql server listens? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
How do you trace the traffic hitting a sql server? : sql server DBA
Why would you call update statistics? : sql server DBA