How do you switch from an init.ora file to a spfile?



How do you switch from an init.ora file to a spfile?..

Answer / gogune

by changing initialization parameter file and with command
create spfile from pfile....

Is This Answer Correct ?    7 Yes 1 No

Post New Answer

More Oracle AllOther Interview Questions

Explain the payment term in ar. : oracle accounts receivable

0 Answers  


what is diff between pre insert,on insert,post insert triggers?

1 Answers   IRISA,


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

0 Answers  


Give two examples of referential integrity constraints.

1 Answers  


How to find locks exists in a table or not?

1 Answers   HCL,






What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

0 Answers  


What is the mandatory setup in cyclecount ?

0 Answers   Oracle,


What is an Oracle database Partial Backup?

0 Answers  


Name two files used for network connection to a database.

1 Answers  


1. What is PO rate variance gain and loss?

0 Answers   Oracle,


What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  


i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

6 Answers   IBM,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)