ALTER TABLE…RENAME PARTITION 和 ALTER TABLE…RENAME SUBPARTITION 命令用于重命名分区或子分区。您必须拥有指定的表才能调用ALTER
TABLE…RENAME PARTITION 或 ALTER TABLE…RENAME SUBPARTITION。
PARTITION europe VALUES('FRANCE', 'ITALY'),
PARTITION asia VALUES('INDIA', 'PAKISTAN'),
PARTITION americas VALUES('US', 'CANADA')
查询视图ALL_TAB_PARTITIONS来显示分区名称：
acctg=# SELECT partition_name, high_value FROM ALL_TAB_PARTITIONS;
partition_name | high_value
----------------+---------------------
europe | 'FRANCE', 'ITALY'
asia | 'INDIA', 'PAKISTAN'
americas | 'US', 'CANADA'
(3 rows)
下列命令将分区americas重命名为n_america：
ALTER TABLE sales
RENAME PARTITION americas TO n_america;
查询视图ALL_TAB_PARTITIONS显示了已成功对分区进行了重命名：
acctg=# SELECT partition_name, high_value FROM ALL_TAB_PARTITIONS;
partition_name | high_value
----------------+---------------------
europe | 'FRANCE', 'ITALY'
asia | 'INDIA', 'PAKISTAN'
n_america | 'US', 'CANADA'
(3 rows)
