How can you gather statistics on a table?

3 Answers  

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

Explain the difference between a data block, an extent and a segment.

2 Answers  

---

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---

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

0 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  

---