CREATE TABLE EMP(
 enum   NUMBER(6)   NOT NULL,
 name   VARCHAR(30) NOT NULL,
  CONSTRAINT EMP_PKEY PRIMARY KEY(enum))
PARTITION BY HASH(enum)
(PARTITION EMP1 TABLESPACE TBS1,
 PARTITION EMP2 TABLESPACE TBS2);

INSERT INTO EMP VALUES( 1, 'James');

SELECT *
FROM EMP PARTITION(EMP1);

CREATE TABLE EMP(
 enum       NUMBER(6)      NOT NULL,
 name       VARCHAR(30)    NOT NULL,
 hired      DATE           NOT NULL,
      CONSTRAINT EMP_PKEY PRIMARY KEY(enum))
PARTITION BY RANGE(hired)
 (PARTITION P1 VALUES LESS THAN
      (TO_DATE('01-JAN-2005', 'DD-MON-YYYY'))
  PARTITION P2 VALUES LESS THAN
      (TO_DATE('01-JAN-2009', 'DD-MON-YYYY'))
);

SELECT *
FROM EMP PARTITION(P2);

CREATE TABLE EMP(
 enum       NUMBER(6)   NOT NULL,
 name       VARCHAR(30) NOT NULL,
 status     CHAR(1)     NOT NULL,
     CONSTRAINT EMP_PKEY PRIMARY KEY(enum))
PARTITION BY LIST(status)
 (PARTITION P1 VALUES ('S','M'),
  PARTITION P2 VALUES ('U'));

SELECT *
FROM EMP
WHERE STATUS = 'U';

CREATE TABLE EMP(
 enum    NUMBER(6)   NOT NULL,
 name    VARCHAR(30) NOT NULL,
 hired   DATE        NOT NULL,
        CONSTRAINT EMP_PKEY PRIMARY KEY(enum))
PARTITION BY RANGE(hired)
SUBPARTITION BY HASH(enum) SUBPARTITIONS 2
 (PARTITION P1 VALUES LESS THAN
      (TO_DATE('01-JAN-2005', 'DD-MON-YYYY'))
      (subpartition P1_1, subpartition P1_2)
PARTITION P2 VALUES LESS THAN
      (TO_DATE('01-JAN-2009', 'DD-MON-YYYY'))
      (subpartition P2_1, subpartition P2_2)
);

CREATE TABLE EMP(
 enum    NUMBER(6)   NOT NULL,
 name    VARCHAR(30) NOT NULL,
 hired   DATE        NOT NULL,
        CONSTRAINT EMP_PKEY PRIMARY KEY(enum))
PARTITION BY RANGE(hired)
SUBPARTITION BY VALUES(name) SUBPARTITIONS 2
 (PARTITION P1 VALUES LESS THAN
      (TO_DATE('01-JAN-2005', 'DD-MON-YYYY'))
      (subpartition P1_1 values('James','Jane')
      subpartition P1_2 values('Kate','Ben'))
...
);