Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

truncating sub partitions

754491Dec 3 2010 — edited Dec 4 2010
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!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 1 2011
Added on Dec 3 2010
3 comments
8,102 views