TRUNCATE TABLE

Description:
The TRUNCATE TABLE command is used to remove all records from a table. An analogue of this command is the DELETE command, only without the WHERE conditions.

Warning: If you clear a table with the TRUNCATE TABLE statement, it cannot be rolled back.

It is important to understand that the TRUNCATE command is fast and does not create entries in the redo file (REDO)

Syntax:
TRUNCATE TABLE [schema.] table
[ {PRESERVE | PURGE} MATERIALIZED VIEW LOG ]
[ {DROP [ ALL ] | REUSE} STORAGE ] ;