Truncate subpartition doesn't remove data

[sambavan]

Hi Folks,

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
REUSE/DROP STORAGE;



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?

Thanx,
Sam