Answer Posted / ron

again to add to my earlier positing, many forget that is the
table has materialized view log truncating table will
corrupt the materialized view.

in that case you have to user:
truncate table schema_name.table_name purge materialized views;

you can read more about it here:
http://www.psoug.org/reference/truncate.html

How to shutdown your 10g xe server?

1101

---

What is the difference between online and offline backups?

996

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2066

---

 How to use an oracle sequence generator in a mapping?

1033

---

How to load excel data sheet to oracle database

982

---

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

1011

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4304

---

What is a tns file?

952

---

How to put more than 1000 values into an oracle in clause?

990

---

How many types of synonyms in Oracle?

1084

---

What is the difference between 10g OEM and 11g OEM?

933

---

How to use "for" statements in oracle?

1032

---

What operating systems are supported by oracle database 10g xe?

998

---

How to drop an index?

922

---

What is a proxy class?

983

---