CODE EXAMPLE FOR SQL

oracle truncate partition

ALTER TABLE table_name TRUNCATE PARTITION partition_name UPDATE INDEXES;