Truncate subpartition doesn't remove data

[sambavan]

Here is the evidence


1 select term_code, count(*)
2 from academic.student_in_section
3 where data_type ='HISTORY'
4 and term_code = 200505
5* group by term_code
SQL> /

TERM_C COUNT(*)
------ ----------
200505 109

SQL> alter table academic.student_in_section truncate subpartition term_200505_history
2 reuse storage;

Table truncated.

SQL> select term_code, count(*)
2 from academic.student_in_section
3 where data_type ='HISTORY'
4 and term_code = 200505
5 group by term_code;

TERM_C COUNT(*)
------ ----------
200505 109

SQL> alter table academic.student_in_section truncate subpartition term_200505_history
2 drop storage;

Table truncated.

SQL> select term_code, count(*)
2 from academic.student_in_section
3 where data_type ='HISTORY'
4 and term_code = 200505
5 group by term_code;

TERM_C COUNT(*)
------ ----------
200505 109




Thanx,
Sam