List partitioning

From Oracle FAQ

List partitioning is a partitioning technique where you specify a list of discrete values for the partitioning key in the description for each partition.

History

List partitioning was introduced with Oracle 9i.

Example

CREATE TABLE myemp_work (
       emp#   NUMBER PRIMARY KEY,
       ename    VARCHAR2(30),
       salary   NUMBER(8,2),
       deptno   NUMBER)
  PARTITION BY LIST (deptno) (  	-- Add list partitioning
       PARTITION p10 VALUES (10), 
       PARTITION p20 VALUES (20), 
       PARTITION p30 VALUES (30,40));