If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

579

---

Tell me about standby database? What should we watch out for?

558

---

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

634

---

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

667

---

What are the steps involved in instance recovery in oracle?

557

---

What is oracle log switch?

629

---

What does the no logging option do? Why would we use it? Why would we be careful of using it?

564

---

How do I call oracle stored procedures that take no parameters?

1133

---

How do I learn what codesets are available in oracle?

1053

---

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1062

---

How do I limit the number of oracle database connections generated by weblogic server?

1085

---

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1099

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1088

---

Why does for update in oracle 8 cause an ora-01002 error?

1019

---

How to pipe multiline string to isql?

1017

---