-- Create table
create table LBI_SYS_VDF.T_S_SYS_LOG
(
LOG_MONTH VARCHAR2(6),
TASK_ID NUMBER not null,
TASK_NAME VARCHAR2(60),
TABLE_NAME VARCHAR2(60),
TASK_SIGN VARCHAR2(20),
START_TIME DATE,
END_TIME DATE,
TASK_STATUS NUMBER(38),
TASK_LOG VARCHAR2(200),
TASK_POS VARCHAR2(512),
ROW_COUNT NUMBER(38)
)
partition by list (LOG_MONTH)
(
partition PRT_M_201412 values ('201412')
tablespace TBS_LBI_SYS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 8M
next 1M
minextents 1
maxextents unlimited
)
);