diff between DELETE and TRUNCATE?.
- 14 Answers
- 19823 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Explain the use of constraints option in exp command.
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is oracle rownum?
What are temporal data types in oracle?
What are data pump export and import modes?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to compare dates in oracle sql?
Can we write dml statement in function in oracle?
What is the difference between hot backup and cold backup in oracle?
What is the difference between translate and replace in oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
What is varray?
material view and view disadvantages?
