This had been a mystry to me. I created a composite patrtition table on a 9i database, whose primary partition is of RANGE and the subpartition of LIST.
Now when I issue
ALTER TABLE table_name
TRUNCATE SUBPARTITION sub_partition_name
it says the "Table truncated". Then when I do a query on the subpartition, it fetches me all the data that was there before the truncate.
Any thoughts on this?