Difference between truncate and delete

1. Delete generates rollback. If a table with a large data volume is deleted, it takes up a lot of rollback segments. truncate is a DDL operation and does not generate rollback, which is faster.



Truncate table does not generate rollback information and redo records so it is much faster than Delete.



In default, it deallocates all space within t the space allocated by minextents unless you specify reuse storage clause.



2. Do not free up space from tablespace.



Alter tablespace AAA coalesce; space available



3. After truncate adjusts high water mark and delete does not. truncate, The hwm of table is returned to the positions of initial and next (default)



Delete is not allowed.



4. truncate can only



Delete can be table, view, and synonym.



5. The truncate table object must be in this mode, or have the permission to drop any table. The delete object must be in this mode, or be authorized to delete on schema. table or delete any table Permissions