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
);
Oracle按月自动进行表分区
点赞
收藏