diff between DELETE and TRUNCATE?.
- 14 Answers
- 18116 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
How many data types are supported?
How to rename a column in an existing table?
Explain how are indexes update?
How to create a new tablespace in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is an external table?
What happens if variable names collide with table/column names?
What is a connect identifier?
What is the data type of dual table?
Explain the difference between sql and oracle?
What is a trace file and how is it created in oracle?
How can you use check constraints for self referential integrity?
What do database buffers contain?
What are the various oracle database objects?
What is format trigger?
