diff between DELETE and TRUNCATE?.
Answer Posted / pr@$@d
1 TRUNCATE is a DDL command whereas DELETE is a DML command.
2 TRUNCATE is much faster than DELETE.
Reason:
a) When you type DELETE. All the data get copied into
the Rollback Table space first. Then delete operation get
performed. That’s why when you type ROLLBACK after deleting
a table, you can get back the data (The system gets it for
you from the Rollback Table space).All this process takes
time. But when you type TRUNCATE, it removes data directly
without copying it into the Rollback Tablespace.Thatswhy
TRUNCATE is faster. Once you truncate you can’t get back
the data.
b) TRUNCATE command resets the High Water Mark for the
table but DELETE does not. So after TRUNCATE the
operations on table are much faster.
3 You can’t rollback in TRUNCATE but in DELETE you can
rollback. TRUNCATE removes the record permanently.
4 In case of TRUNCATE, Trigger doesn't get fired.But in DML
commands like DELETE .Trigger get fired.
5 You can’t use conditions (WHERE clause) in TRUNCATE.But
in DELETE you can write conditions using WHERE clause
Regards,
-Pr@$@d Reddi.
prasadreddi_mca@yahoo.com
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is an oracle function?
Explain the use of file option in exp command.
defination of bitmap index
Explain the difference between sql and oracle?
Who developed oracle & when?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Can group functions be used in the order by clause in oracle?
How to convert times to characters in oracle?
What types of joins are used in writing subqueries?
How to create a new table by selecting rows from another table?
what is reindexing?
How do I escape a reserved word in oracle?
Is oracle the best database?
Can multiple cursors being opened at the same time?
How do I uninstall oracle client from windows?