The Oracle TRUNCATE statement removes all records from a table.
The operation cannot be rolled back and no triggers will be fired.
As such, TRUNCATE is faster and doesn’t use as much undo space as a DELETE.
TRUNCATE TABLE [schema.]tablename [{PRESERVE|PURGE} MATERIALIZED VIEW LOG] [{DROP | REUSE} STORAGE]
TRUNCATE CLUSTER [schema.]cluster [{DROP | REUSE} STORAGE]
Example 1:
TRUNCATE TABLE country;