T_S_TAB_PARTITION_ADD_MID和T_S_TAB_PARTITION_DEL_MID

-- Create table
create table LBI_SYS_VDF.T_S_TAB_PARTITION_ADD_MID
(
  TABLE_OWNER    VARCHAR2(30),
  TABLE_NAME     VARCHAR2(30),
  PARTITION_NAME VARCHAR2(30)
)
tablespace TBS_LBI_SYS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

 

-- Create table
create table LBI_SYS_VDF.T_S_TAB_PARTITION_DEL_MID
(
TABLE_OWNER VARCHAR2(30),
TABLE_NAME VARCHAR2(30),
PARTITION_NAME VARCHAR2(30),
DEAL_CYCLE VARCHAR2(8),
LAST_DAY_TYPE_ID VARCHAR2(1),
MAX_DELETE_DATE VARCHAR2(12)
)
tablespace TBS_LBI_SYS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);