How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

---

What is the difference between Datapump & export/import?

2 Answers  

---

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  

---

What is dbcc? : sql server DBA

0 Answers  

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

Name three advisory statistics you can collect.

1 Answers  

---

what is ora 600?

1 Answers  

---

How would you determine who has added a row to a table?

4 Answers  

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

---

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

0 Answers  

---