top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is the difference between deleting and truncating of tables in Oracle?

+1 vote
956 views
What is the difference between deleting and truncating of tables in Oracle?
posted Oct 15, 2014 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

Deleting a table will not remove the rows from the table but entry is there in the database dictionary and it can be retrieved But truncating a table deletes it completely and it cannot be retrieved.

answer Oct 16, 2014 by Arun Gowda
...