oracle建按月分区的表,Oracle按月自动进行表分区

create table HIP_LOG_NODE_Part

(

ID                   VARCHAR2(32)         not null,

LOG_ID               VARCHAR2(32),

BUSINESS_ID          VARCHAR2(36),

NODE_ID              VARCHAR2(32),

NODE_NAME            VARCHAR2(80),

STATE                VARCHAR2(2),

STATE_CLASS          VARCHAR2(2),

TIME_CONSUMING       NUMBER,

INPUT_MSG            CLOB,

OUTPUT_MSG           CLOB,

ERROR_CODE           VARCHAR2(12),

ERROR_NAME           VARCHAR2(300),

ERROR_INFO           CLOB,

RECORD_TIME          DATE,

VERTEX_ID            VARCHAR2(32)

)tablespace TB_HIP_LOG_NODE

PARTITION BY RANGE (RECORD_TIME) interval (numtoyminterval(1, 'month'))

STORE IN (TB_HIP_LOG_NODE)

(

partition hip_log_node_partition values less than (to_date('2019-08-01 00:00','yyyy-MM-dd HH24:mi')) tablespace TB_HIP_LOG_NODE

);