Example - Adding a Partition to a LIST Partitioned Table v11
The example that follows adds a partition to the list-partitioned sales
table. The table was created using the command:
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') );
The table contains three partitions (americas, asia
, and europe
).
edb=# SELECT partition_name, high_value FROM ALL_TAB_PARTITIONS; partition_name | high_value ----------------+------------------------------------- EUROPE | FOR VALUES IN ('FRANCE', 'ITALY') ASIA | FOR VALUES IN ('INDIA', 'PAKISTAN') AMERICAS | FOR VALUES IN ('US', 'CANADA') (3 rows)
The following command adds a partition named east_asia
to the sales
table.
ALTER TABLE sales ADD PARTITION east_asia VALUES ('CHINA', 'KOREA');
After invoking the command, the table includes the east_asia
partition.
edb=# SELECT partition_name, high_value FROM ALL_TAB_PARTITIONS; partition_name | high_value ----------------+------------------------------------- EUROPE | FOR VALUES IN ('FRANCE', 'ITALY') ASIA | FOR VALUES IN ('INDIA', 'PAKISTAN') AMERICAS | FOR VALUES IN ('US', 'CANADA') EAST_ASIA | FOR VALUES IN ('CHINA', 'KOREA') (4 rows)