create table LBI_SYS_VDF.T_S_YYYY_MM_WW_DD
(
YEAR VARCHAR2(4),
MONTH VARCHAR2(7),
WEEK VARCHAR2(7),
DAY VARCHAR2(10),
YYYYMMDD VARCHAR2(8) not null,
MONTH_ORDER VARCHAR2(6),
WEEK_ORDER VARCHAR2(6),
DAY_ORDER VARCHAR2(8),
YEAR_ORDER VARCHAR2(4)
)
tablespace TBS_LBI_SYS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table LBI_SYS_VDF.T_S_YYYY_MM_WW_DD
add constraint PK_T_S_YYYY_MM_WW_DD primary key (YYYYMMDD)
using index
tablespace TBS_LBI_SYS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
(
YEAR VARCHAR2(4),
MONTH VARCHAR2(7),
WEEK VARCHAR2(7),
DAY VARCHAR2(10),
YYYYMMDD VARCHAR2(8) not null,
MONTH_ORDER VARCHAR2(6),
WEEK_ORDER VARCHAR2(6),
DAY_ORDER VARCHAR2(8),
YEAR_ORDER VARCHAR2(4)
)
tablespace TBS_LBI_SYS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table LBI_SYS_VDF.T_S_YYYY_MM_WW_DD
add constraint PK_T_S_YYYY_MM_WW_DD primary key (YYYYMMDD)
using index
tablespace TBS_LBI_SYS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);