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
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
when does an alert gets signaled?
What are the steps you will take to improve performance of a poor performing query?
what do you understand by flashback feature of oracle?
internal architecture
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.
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
Why would you use sql agent? : sql server DBA
What is a correlated sub-query? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Explain about your sql server dba experience? : sql server DBA
how can you enable flashback feature?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you process messages in order asynchronously?