diff between DELETE and TRUNCATE?.
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
What are the attributes that are found in a cursor?
What is an oracle data file?
What is data type in oracle?
What are the limitations of check constraint?
What are the limitations oracle database 10g xe?
Can we use bind variables in oracle stored procedure?
State and explain the different types of data models?
Which are the five query types available in oracle?
How to use "while" statements in oracle?
How to add a new column to an existing table with a default value?
What are internal user account in oracle?
What is a synonym? What are its various types?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
How many types of synonyms in Oracle?
How can we view last record added to a table?