Interested to Buy Any Domain ? << Click Here >> for more details...
How do you switch from an init.ora file to a spfile?
- 4 Answers
- 19745 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srinivasarao
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 ? | 9 Yes | 1 No |
Post New Answer View All Answers
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
how can a session indicate its interest in receiving alerts?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is the diffrence between core dba and apps dba?
How can you control the amount of free space in your index pages? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
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
who owns the operating system files created by the utl_file package?
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.
Query processing is slow(eg select query)how will u solve that
What is a system database and what is a user database? : sql server DBA
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 is the difference between the 2 operating modes of database mirroring? : sql server DBA
what is a user-defined lock?
