Interested to Buy Any Domain ? << Click Here >> for more details...
How do you switch from an init.ora file to a spfile?
- 4 Answers
- 20106 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 is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What types of replication are supported in sql server? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
how can you schedule a job in database?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
how can you enable flashback feature?
What would you do with an "in-doubt" distributed transaction?
what is a crs resource?
What is the importance of a recovery model? : sql server DBA
what are the types of connection load-balancing?
what functionality does oracle provide to secure sensitive information?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how to restore files with rman?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What purpose does the model database server? : sql server DBA
