How do we switch from init.ora file to asp file?

Answers were Sorted based on User's Feedback



How do we switch from init.ora file to asp file?..

Answer / sachin

we can switch from init.ora file to a sp file with the help
of the command
create spfile from
pfile='c:\oracle\database_name\pfile\init.ora'

Is This Answer Correct ?    2 Yes 0 No

How do we switch from init.ora file to asp file?..

Answer / sachin

we can switch from init.ora file to a sp file with the help
of the command
create spfile from
pfile='c:\oracle\database_name\pfile\init.ora'

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle General Interview Questions

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

0 Answers  


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  


What WHERE CURRENT OF clause does in a cursor?

2 Answers  


How do you bind variables in oracle?

0 Answers  


How to get maxsal , minsal, ename department wise in single query

0 Answers  






What is cluster Key ?

3 Answers  


What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

0 Answers   CGI,


What is schema?

41 Answers   Bodhi Global Services, Cognizant, HCL,


If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

7 Answers   IBM,


What is a table index?

0 Answers  


how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

1 Answers   IBM,


25. Display the client number and the value of the highest value order placed by that client.

2 Answers   Wipro,


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)