Truncating 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.