Oracle Database Discussions

I am using oracle11g. I want to truncate subpartition on specific partion.

I have partition on statewise. Each state partion has 7 day partition.

For intance,

Partion TX
Sub partition MON, TUE, WED, THU, FRI, SAT, SUN

Partion CA
Sub partition MON, TUE, WED, THU, FRI, SAT, SUN


Partion IA
Sub partition MON, TUE, WED, THU, FRI, SAT, SUN

Now i want to perform following tasks.

1. Need to truncate TUE sub partiion on TX partition.
2. Need to truncate WED sub partiion on CA partition.
3. Need to truncate SUN sub partiion on IA partition.

How do we do this?

The below statment truncate all TUE partition on all the partitions.

ALTER TABLE TRX_TABLE
TRUNCATE SUBPARTITION TUE;

How do i tuncate specfic sub partition on specific partition?

Any help is appreciated!!