How to Truncate TABLE in Oracle

  • We can use truncate table command to delete all the rows  in the table and it releases all the storage space allocated to the table. It resets the high water mark of the table
  • This command cannot be rollback
  • You should be owner of the table to execute the operation

-Truncating the table is a DDL command and it does not fire the on delete triggers

-We can delete all the rows in the table by delete command also but it does not release the storage space allocated to  the table

Leave a Reply