Truncate a Partition

You can delete all the information in a partition without affecting information in other partitions.

For example, to delete all rows from the q1 and q2 partitions of the fictionsales table, enter:
truncate table fictionsales partition q1
truncate table fictionsales partition q2

See the Reference Manual: Commands.