List partitioning

From Oracle FAQ
Jump to: navigation, search

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[edit]

List partitioning was introduced with Oracle 9i.

Example[edit]

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