Oracle用分区表分区交换做历史数据迁移(三)
4_1 TAN_2014_1
TAN TAN_2013_9 USERS
12 rows selected.
SQL> alter table tan drop partition tan_2013_9;
Table altered.
SQL> select table_name,partition_name,tablespace_name from user_tab_partitions;
TABLE_NAME PARTITION_NAME TABLESPACE_NAME
------------------------------ ------------------------------ ------------------------------
TAN TAN_2014_3 TAN_2014_3
TAN TAN_2014_2 TAN_2014_2
TAN TAN_2014_4 TAN_2014_4
TAN TAN_2014_5 TAN_2014_5
TAN TAN_2014_6 TAN_2014_6
TAN TAN_2014_7 TAN_2014_7
TAN TAN_2014_8 TAN_2014_8
TAN TAN_2013_10 TAN_2013_10
TAN TAN_2013_11 TAN_2013_11
TAN TAN_2013_12 TAN_2013_12
TAN TAN_2014_1 TAN_2014_1