允许用户将不相关的数据组织在一起
语法:
PARTITION BY LIST (column_name)
(
PARTITION part1 VALUES (values_list1),
PARTITION part2 VALUES (values_list2),
...
PARTITION partN VALUES (DEFAULT)
);
例:
CREATE TABLE Employee
(
Emp_ID number (4),
Emp_Name varchar2 (14),
Emp_Address varchar2 (15)
)
PARTITION BY LIST (Emp_Address)
(
Partition north values (‘芝加哥'),
Partition west values (‘旧金山’, ‘洛杉矶'),
Partition south values (‘亚特兰大’, ‘达拉斯’, ‘休斯顿'),
Partition east values (‘纽约’, ‘波斯顿')
);