I try to create partition table like in listing below:
CREATE TABLE SOME_TABLE
(
COL1 NUMBER(2),
COL2 VARCHAR(45),
.
.
COLXX VARCHAR(30)
)
PARTITION BY RANGE(COL1) SUBPARTITION BY HASH(COL2)
(PARTITION part_less_2 VALUES LESS THAN (2) TABLESPACE tbs_1
PARTITION part_less_11 VALUES LESS THAN (11) TABLESPACE tbs_2
PARTITION part_maxval VALUES LESS THAN (MAXVALUE) TABLESPACE tbs_3);
Could someone explain me why I've got ORA-14020 as an output?