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


Please Help Members By Posting Answers For Below Questions

How do you open a cluster administrator? : sql server DBA

581


how can a session indicate its interest in receiving alerts?

567


what do you understand by fine-grained auditing?

637


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.

1509


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?

2974






What are the commands you'd issue to show the explain plan for "select * from dual"?

1733


who owns the operating system files created by the utl_file package?

569


internal architecture

1759


what functionality does oracle provide to secure sensitive information?

558


What is the default port no on which sql server listens? : sql server DBA

564


How can you control the amount of free space in your index pages? : sql server DBA

743


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

1909


how can you generate profile of pl/sql applications to identify performance bottlenecks?

603


How do you trace the traffic hitting a sql server? : sql server DBA

848


Why would you call update statistics? : sql server DBA

582