CREATE TABLE T_SC_PHOTO (
portrait_id VARCHAR2 (40),
photo_start VARCHAR2 (2),
file_url VARCHAR2 (100),
date_time DATE,
photo_type VARCHAR2 (2)
)
PARTITION BY RANGE (date_time) INTERVAL (NUMTOYMINTERVAL(1, 'MONTH'))
(
PARTITION T_SC_PHOTO_1 VALUES LESS THAN (TO_DATE ('2017-09-01', 'YYYY-MM-DD'))
);
这是我写的一个创建分区的sql，
但是一直在报错：
[SQL]PARTITION BY RANGE (date_time) INTERVAL (NUMTOYMINTERVAL(1, 'MONTH'))
(
PARTITION T_SC_PHOTO_1 VALUES LESS THAN ( TO_DATE ('2017-09-01', 'YYYY-MM-DD'))
)
[Err] ORA-00900: invalid SQL statement
请问一下我是哪里写错了吗？