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
);

转载于:https://www.cnblogs.com/springmonkey/p/11397998.html