Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22513 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
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?
What is a proxy object?
material view and view disadvantages?
Why do we use coalesce function in oracle?
What is a trigger and what are its types in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
How to use like conditions in oracle?
What is parameterized cursor in oracle?
What are the various types of snapshots ?
How can I see all tables in oracle?
How to define a record variable to store a table row?
What are the different types of partitions in oracle?
How to check your oracle database 10g xe installation?
What are the common oracle dba tasks?
master table and child table performances and comparisons in Oracle ?
