【实验】【PARTITION】RANGE分区表重命名表分区(Rename Partition)

2019-12-31 16:11:39

1.先看一下我这个分区表的分区情况
sec@ora10g> select table_name,partition_name,high_value,tablespace_name from user_tab_partitions where table_name='T_PARTITION_RANGE' order by partition_position;

TABLE_NAME           PARTITION_NAME       HIGH_VALUE TABLESPACE_NAME
-------------------- -------------------- ---------- ---------------
T_PARTITION_RANGE    T_RANGE_P1           10         TBS_PART03
T_PARTITION_RANGE    T_RANGE_P2           MAXVALUE   TBS_PART04

2.目标：将T_RANGE_P2的名字修改为T_RANGE_PMAX
sec@ora10g> alter table t_partition_range rename partition T_RANGE_P2 to T_RANGE_PMAX;

Table altered.

3.验证一下
sec@ora10g> select table_name,partition_name,high_value,tablespace_name from user_tab_partitions where table_name='T_PARTITION_RANGE' order by partition_position;

TABLE_NAME           PARTITION_NAME       HIGH_VALUE TABLESPACE_NAME
-------------------- -------------------- ---------- ---------------
T_PARTITION_RANGE    T_RANGE_P1           10         TBS_PART03
T_PARTITION_RANGE    T_RANGE_PMAX         MAXVALUE   TBS_PART04

-- The End --

分享好友

分享这个小栈给你的朋友们，一起进步吧。