Skip navigation.

arunbharat2001's blog

Diff B/W Truncate & Delete

1.DML data can be recovered by rollback before commit
2.Remove any subset of data
3.Delete is slower when table have numerous indexes and triggers
4.DML triggers fire for delete mthod can be recovered after commit by flashback method
6.high water mark will remain the same deleted info capture with returning clause
8. you can not delete data if function based index is invalid
9. can not delete data from complex views.