-- Create table
create table LBI_SYS_VDF.T_S_TAB_PARTITION
(
OWNER VARCHAR2(250),
TABLE_NAME VARCHAR2(250),
PARTITION_NAME VARCHAR2(250),
TABLESPACE_NAME VARCHAR2(250),
TABLESPACE_NAME_ODD VARCHAR2(250),
TABLESPACE_NAME_EVEN VARCHAR2(250),
COMPRESSION VARCHAR2(1),
PARTITION_COUNT NUMBER(38),
PARTITION_DATE DATE,
PROC_FLAG_ID VARCHAR2(1),
DEAL_CYCLE VARCHAR2(8),
PARTITION_TYPE_ID VARCHAR2(1),
TABLESPACE_TYPE_ID VARCHAR2(1),
LAST_DAY_TYPE_ID VARCHAR2(1),
DATE_TYPE_ID VARCHAR2(1),
MAX_DELETE_DATE VARCHAR2(14)
)
tablespace TBS_LBI_SYS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create table LBI_SYS_VDF.T_S_TAB_PARTITION
(
OWNER VARCHAR2(250),
TABLE_NAME VARCHAR2(250),
PARTITION_NAME VARCHAR2(250),
TABLESPACE_NAME VARCHAR2(250),
TABLESPACE_NAME_ODD VARCHAR2(250),
TABLESPACE_NAME_EVEN VARCHAR2(250),
COMPRESSION VARCHAR2(1),
PARTITION_COUNT NUMBER(38),
PARTITION_DATE DATE,
PROC_FLAG_ID VARCHAR2(1),
DEAL_CYCLE VARCHAR2(8),
PARTITION_TYPE_ID VARCHAR2(1),
TABLESPACE_TYPE_ID VARCHAR2(1),
LAST_DAY_TYPE_ID VARCHAR2(1),
DATE_TYPE_ID VARCHAR2(1),
MAX_DELETE_DATE VARCHAR2(14)
)
tablespace TBS_LBI_SYS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);