Answer / 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.

Answer / 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.

Answer / ramakrishnach.dba

oracle searches parameter file in following manner

1) spfile$ORACLE_SID.ora
2) spfile.ora
3) init$ORACLE_SID.ora
4) init.ora

if oracle finds spfile$ORACLE_SID.ora file it ignores rest of the files

Answer / ravindra

create pfile from spfile;

how can you create a user-defined lock?

0 Answers   Oracle,

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

---

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.

0 Answers  

---

Can you redefine a table online?

0 Answers   Oracle,

---

What is checkpoint?

3 Answers   Accenture,

---

how can you initialize log miner?

0 Answers   Oracle,

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

If CPU is very slow What can u do to speed up?

1 Answers  

---