What could be the cause of the below failure please?
CREATE TABLE TAB
(
SOURCE VARCHAR2(4000 BYTE),
JOB VARCHAR2(4000 BYTE),
LDATE DATE
)
NOCOMPRESS
TABLESPACE USERS
PARTITION BY RANGE (LDATE)
SUBPARTITION BY HASH (JOB)
SUBPARTITION TEMPLATE
(SUBPARTITION MAL_JOB1 TABLESPACE USERS,
SUBPARTITION MAL_JOB2 TABLESPACE USERS,
SUBPARTITION MAL_JOB3 TABLESPACE USERS,
SUBPARTITION MAL_JOB4 TABLESPACE USERS,
SUBPARTITION MAL_JOB5 TABLESPACE USERS,
SUBPARTITION MAL_JOB6 TABLESPACE USERS,
SUBPARTITION MAL_JOB7 TABLESPACE USERS,
SUBPARTITION MAL_JOB8 TABLESPACE USERS
)
(
PARTITION JUL252015_06 VALUES LESS THAN (TO_DATE(' 2015-07-25 06:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
( SUBPARTITION JUL252015_06_MAL_JOB1 TABLESPACE USERS,
SUBPARTITION JUL252015_06_MAL_JOB2 TABLESPACE USERS,
SUBPARTITION JUL252015_06_MAL_JOB3 TABLESPACE USERS,