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 / 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
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is asm?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Can you redefine a table online?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What are the different types of indexes available in sql server? : sql server DBA
how can you initialize log miner?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
suppose you want to audit specific activities on sensitive data. How can you achieve that?
How would you extract DDL of a table without using a GUI tool?
What are the commands used in dcl? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : 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 is a correlated sub-query? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
