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 get execution path reports on query statements?

1042

---

Are truncate and delete commands same? If so why?

1200

---

What is the fastest query method to fetch data from the table?

1412

---

What is an anonymous block?

1323

---

Explain an integrity constrains?

1190

---

How to handle a single quote in oracle sql?

1096

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2040

---

How to define a data source name (dsn) in odbc manager?

1078

---

How many types of table in Oracle?

1170

---

What is the minimum client footprint required to connect c# to an oracle database?

1161

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2189

---

What is the difference between count (*), count (expression), count (distinct expression)?

1046

---

Can we create database in oracle using command line ?

1129

---

How to create a testing table in oracle?

1031

---

Difference between pre-select and pre-query

1173

---