-- Create table
create table SER_BILLS
(
STREAMNUMBER NUMBER(38) not null,
SERVICEKEY NUMBER(38),
CHARGEMODE CHAR(1),
CHARGERECORDID NUMBER(38),
CALLINGPARTYNUMBER CHAR(24),
CALLEDPARTYNUMBER CHAR(24),
TRANSLATEDPARTYNUM CHAR(24),
LOCATIONNUMBER CHAR(4),
CHARGEDPARTYIDIND NUMBER(38),
SPECIFICCHARGEPART CHAR(22),
STARTDATEANDTIME CHAR(14),
STOPDATEANDTIME CHAR(14),
DURATION NUMBER(38),
CALLCOST NUMBER(38),
BEARERCAPABILITY CHAR(4),
CHARGECLASS NUMBER(38),
SPECIFICCHGPRTTYPE NUMBER(38),
USERID NUMBER(38),
SUBSERVICENUMBER CHAR(28),
FEECOUNT NUMBER(38),
BASECALLCOST NUMBER(38),
EXTRACALLCOST NUMBER(38),
CHARGECURRENCY NUMBER(38),
TRANSPARENTPARAM CHAR(40),
STARTDATETIME DATE
)
partition by range (STARTDATETIME)
(
partition DT0 values less than (TO_DATE(' 2009-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace FOREST_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
)
);
-- Create/Recreate indexes
create index CALLEDPART on SER_BILLS (CALLEDPARTYNUMBER)
tablespace FOREST_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create index STARTDATEPART on SER_BILLS (STARTDATETIME)
tablespace FOREST_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
SER_BILLS
最新推荐文章于 2022-10-11 02:21:19 发布