Interested to Buy Any Domain ? << Click Here >> for more details...
How do you switch from an init.ora file to a spfile?
- 4 Answers
- 19978 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 are the benefits of flashback feature?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
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?
what is the diffrence between core dba and apps dba?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is a system database and what is a user database? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
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?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Why does Oracle not permit the use of PCTUSED with indexes?
how can you communicate with operating system files from oracle?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what is the use of recording information about current session?
