Example - Renaming a Partition v13

The following command creates a list-partitioned table named sales:

CREATE TABLE sales
(
  dept_no     number,
  part_no     varchar2,
  country     varchar2(20),
  date        date,
  amount      number
)
PARTITION BY LIST(country)
(
  PARTITION europe VALUES('FRANCE', 'ITALY'),
  PARTITION asia VALUES('INDIA', 'PAKISTAN'),
  PARTITION americas VALUES('US', 'CANADA')
);

Query the ALL_TAB_PARTITIONS view to display the partition names.

edb=# SELECT partition_name, high_value FROM ALL_TAB_PARTITIONS;
 partition_name |     high_value
----------------+---------------------
 EUROPE         | 'FRANCE', 'ITALY'
 ASIA           | 'INDIA', 'PAKISTAN'
 AMERICAS       | 'US', 'CANADA'
(3 rows)

The following command renames the americas partition to n_america.

ALTER TABLE sales
 RENAME PARTITION americas TO n_america;

Querying the ALL_TAB_PARTITIONS view demonstrates that the partition has been successfully renamed.

edb=# 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)

← Prev

ALTER TABLE...RENAME PARTITION

ALTER TABLE...SET INTERVAL

Example - Renaming a Partition v13

← Prev

Next →