按年：

PARTITION BY RANGE (CREATE_TIME) INTERVAL (numtoyminterval(**1**, 'year'))

按月：

PARTITION BY RANGE (CREATE_TIME) INTERVAL (numtoyminterval(**1**, 'month'))

按天：

PARTITION BY RANGE (CREATE_TIME) INTERVAL (NUMTODSINTERVAL(**1**, 'day'))

按周：

PARTITION BY RANGE (CREATE_TIME) INTERVAL (NUMTODSINTERVAL (**7**, 'day'))