Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22660 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 to define a cusotmer as a supplier in ORACLE R12
What are nested tables?
What happens if recursive calls get out of control?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to use "startup" command to start default instance?
What is a lookup table in oracle?
What is a trigger and what are its types?
What is a tns file?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How do I recompile a procedure in oracle?
What do database buffers contain?
Is oracle a relational database?
How to pass parameters to procedures?
How to import one table back from a dump file?
What are the limitations oracle database 10g xe?
