create table T_COMPLEX(
    ID NUMBER,
    TIME_ID DATE
    )
    partition by list (ID)
    SUBPARTITION BY HASH (TIME_ID)
    SUBPARTITIONS 4 STORE IN (D01, D02, D03,D04)
    (
        partition k1 VALUES LESS THAN ('27-DEC-04'), -- подчеркивает "LESS" как ошибку
        partition k2 VALUES LESS THAN ('17-APR-08'),
        partition k3 VALUES LESS THAN ('12-OCT-12')
    );

ORA-00906: missing left parenthesis
00906. 00000 -  "missing left parenthesis"

create table T_COMPLEX(
    ID NUMBER,
    TIME_ID DATE
    )
    partition by list (ID)
    (
    partition p1 values (1,2) ,
    partition p2 values (3,4,5) ,
    partition p3 values (6,7,8) 
    )
    SUBPARTITION BY HASH (TIME_ID) -- подчеркивает BY как ошибка
    SUBPARTITIONS 4 STORE IN (D01, D02, D03,D04)
    (
        partition k1 VALUES LESS THAN ('27-DEC-04'),
        partition k2 VALUES LESS THAN ('17-APR-08'),
        partition k3 VALUES LESS THAN ('12-OCT-12')
    );