Re: What is difference between turnacate and delete ? see Page 19-67 of the 11.2 SQL Language Reference (or just search for TRUNCATE TABLE in whatever version of the SQL Language Reference you have handy). Also you might try Googling for "oracle difference truncate delete" which might return a few hits.