How to Truncate TABLE in Oracle

Last updated on September 1st, 2019 at 06:28 pm

  • 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

Related Articles

Oracle Create table Syntax,Tip and Examples

Query to check table size in Oracle

How to List All Tables in Oracle

Leave a Reply