How do we switch from init.ora file to asp file?
Answers were Sorted based on User's Feedback
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 |
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 I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What WHERE CURRENT OF clause does in a cursor?
How do you bind variables in oracle?
How to get maxsal , minsal, ename department wise in single query
What is cluster Key ?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
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?
What is a table index?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
25. Display the client number and the value of the highest value order placed by that client.