Truncate subpartition doesn't remove data
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?
Last edited by sambavan; 08-10-2005 at 12:51 PM.
Life is a journey, not a destination!