Interested to Buy Any Domain ? << Click Here >> for more details...
How do you switch from an init.ora file to a spfile?
- 4 Answers
- 19747 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / santo
Just create a spfile for pfile and then bounce the
database...While restarting, if Oracle finds spile first it
will use it first instead on pfile.
| Is This Answer Correct ? | 28 Yes | 1 No |
Post New Answer View All Answers
how can you find out if a table can be redefined?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Can you redefine a table online?
how can you enable flashback feature?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
what is grd?
How do you open a cluster administrator? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
how does an oracle clusterware manage crs resources?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
what do you understand by flashback feature of oracle?
Why would you use sql agent? : sql server DBA
