Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22027 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
What is Virtual Private Database in Oracle?
Explain table?
What is Segment Advisor in Oracle?
What are the different types of failures that occur in Oracle database?
What is null value in oracle?
How to start instance with a minimal initialization parameter file?
How to count duplicated values in a column in oracle?
Will you be able to store pictures in the database?
What is blob data type in oracle?
Can you drop an index associated with a unique or primary key constraint?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What is an Oracle Instance?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to call a stored function with parameters?
How to rollback the current transaction in oracle?
