Interested to Buy Any Domain ? << Click Here >> for more details...
How do you switch from an init.ora file to a spfile?
- 4 Answers
- 19723 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
what is the role of dip user in our database?
Where do you find the default index fill factor and how to change it? : sql server DBA
what is a crs resource?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What is dcl? : sql server DBA
What are the recovery models for a database? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is the diffrence between core dba and apps dba?
internal architecture
Why would you use sql agent? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
which background process invoke at the time of upgradation tell me???
