How do you switch from an init.ora file to a spfile?
Answer Posted / ravindra
create pfile from spfile;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
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?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
who owns the operating system files created by the utl_file package?
What is the default port no on which sql server listens? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how can you get actual data change values from previous transactions in oracle?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : 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?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is the difference between clustered and non-clustered index? : sql server DBA
how can you create a user-defined lock?