-- Create table
create table V_MEMBER_FUNDS_STAT_CLIENT
(
cleardate DATE,
memberno VARCHAR2(20),
membername VARCHAR2(500),
begincapital NUMBER(15,2),
fundio NUMBER(15,2),
memberfee NUMBER,
mktfee NUMBER,
customerfee NUMBER,
memberclosepl NUMBER(15,2),
memberholdpl NUMBER(15,2),
customerdelayfee NUMBER,
smemberdelayfee NUMBER,
delayfeesum NUMBER,
endcapital NUMBER(15,2),
status CHAR(1),
risk NUMBER,
get_customer_storage_fee NUMBER(15,2),
give_sm_storage_fee NUMBER(15,2),
member_retention_storage_fee NUMBER(15,2)
)
partition by range (CLEARDATE)
(
partition V_MEMBER_TRADE_FUNDS_STAT_P1 values less than (TO_DATE(' 2011-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
),
partition SYS_P707 values less than (TO_DATE(' 2013-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
),
partition SYS_P705 values less than (TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
),
partition SYS_P706 values less than (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
)
);
create table V_MEMBER_FUNDS_STAT_CLIENT
(
cleardate DATE,
memberno VARCHAR2(20),
membername VARCHAR2(500),
begincapital NUMBER(15,2),
fundio NUMBER(15,2),
memberfee NUMBER,
mktfee NUMBER,
customerfee NUMBER,
memberclosepl NUMBER(15,2),
memberholdpl NUMBER(15,2),
customerdelayfee NUMBER,
smemberdelayfee NUMBER,
delayfeesum NUMBER,
endcapital NUMBER(15,2),
status CHAR(1),
risk NUMBER,
get_customer_storage_fee NUMBER(15,2),
give_sm_storage_fee NUMBER(15,2),
member_retention_storage_fee NUMBER(15,2)
)
partition by range (CLEARDATE)
(
partition V_MEMBER_TRADE_FUNDS_STAT_P1 values less than (TO_DATE(' 2011-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
),
partition SYS_P707 values less than (TO_DATE(' 2013-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
),
partition SYS_P705 values less than (TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
),
partition SYS_P706 values less than (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
)
);