Answer Posted / balu

exec dbms_stats.gather_table_stats('ownername','tablename')

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

2014

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1917

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2418

---

Can you redefine a table online?

1098

---

What is dcl? : sql server DBA

1237

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1184

---

What are the different ways you can create databases in sql server? : sql server DBA

1115

---

how can you find out if a table can be redefined?

989

---

. 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?

2430

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1738

---

how can you initialize log miner?

1113

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2420

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2448

---

What authentication modes does sql server support? : sql server DBA

1190

---

What are the different sql server versions you have worked on? : sql server DBA

996

---