Interested to Buy Any Domain ? << Click Here >> for more details...
How do you switch from an init.ora file to a spfile?
- 4 Answers
- 19942 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
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Can you redefine a table online?
how can you communicate with operating system files from oracle?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
what is asm?
What is the difference between dropping a database and taking a database offline? : sql server DBA
what do you understand by flashback feature of oracle?
what are the performance views in an oracle rac environment?
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.
Which autogrowth database setting is good? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are the different types of indexes available in sql server? : sql server DBA
