Answer Posted / 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 View All Answers
Difference between varchar and varchar2 data types?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is the difference between post-database commit and post-form commit?
How to convert dates to characters in oracle?
Explain about integrity constraint?
what are archived logs?
Give the various rollback segment states.
What are the attributes of the cursor?
What is max rowid in oracle?
How to view all columns in an existing table?
Oracle
Explain what are clusters?
What is the parameter mode that can be passed to a procedure?
Can you drop an index associated with a unique or primary key constraint?
How to define an oracle sub procedure?