* How do you reclaim space from a table partition?


SQL> select EXTENT_ID,blocks from  user_extents where
SEGMENT_NAME='PAR_TEST' and PARTITION_NAME='P2
';

 EXTENT_ID     BLOCKS
---------- ----------
         0          8
         1          8
         2          8
         3          8
         4          8

SQL> alter table par_test truncate partition p2 drop storage;

Table truncated.

SQL> select EXTENT_ID,blocks from  user_extents where
SEGMENT_NAME='PAR_TEST' and PARTITION_NAME='P2
';

 EXTENT_ID     BLOCKS
---------- ----------
         0          8

SQL> 

SQL> select EXTENT_ID,blocks from  user_extents where
SEGMENT_NAME='PAR_TEST' and PARTITION_NAME='P3
';

 EXTENT_ID     BLOCKS
---------- ----------
         0          8
         1          8
         2          8
         3          8
         4          8

SQL> alter table par_test truncate partition p3 reuse storage;

Table truncated.

SQL> select EXTENT_ID,blocks from  user_extents where
SEGMENT_NAME='PAR_TEST' and PARTITION_NAME='P3
';

 EXTENT_ID     BLOCKS
---------- ----------
         0          8
         1          8
         2          8
         3          8
         4          8

SQL>