不是物化视图,以下是此表的定义
-- Create table
create table CDRMAIN_OR
(
VERSION NUMBER(10) default 0,
NODEID NUMBER(10) default 0,
STARTTIME NUMBER(10) default 0,
ENDTIME NUMBER(10) default 0,
GMTOOFFSET NUMBER(10) default 0,
LOCALDAY NUMBER(8) default 0,
DAYOFWEEK NUMBER(2) default 0,
SESSIONID NUMBER(10) default 0,
SEQUENCEID NUMBER(10) default 0,
TRUNKCALL NUMBER(1) default 0,
DIRECTION NUMBER(1) default 0,
ORIGINALPRIORITY NUMBER(10) default 0,
STARTPRIORITY NUMBER(10) default 0,
ENDPRIORITY NUMBER(10) default 0,
CALLERTYPE NUMBER(2) default 0,
CALLERPAD VARCHAR2(5),
CALLERNUM VARCHAR2(41),
CALLERNAME VARCHAR2(65),
CALLERTENANT VARCHAR2(33),
CALLERPROJECT NUMBER(10) default 0,
TARGETTYPE NUMBER(2) default 0,
TARGETNUM VARCHAR2(41),
TARGETNAME VARCHAR2(65),
TARGETPAD VARCHAR2(20),
TARGETTENANT VARCHAR2(33),
TARGETPROJECT NUMBER(10) default 0,
TARGETWGNUM VARCHAR2(33),
WGSESSIONID NUMBER(10) default 0,
OUTGOINGWG NUMBER(10) default 0,
CONFSESSIONID NUMBER(10) default 0,
DNIS VARCHAR2(33),
ACCOUNDCODE VARCHAR2(11),
AADURATION NUMBER(10) default 0,
RINGDURATION NUMBER(10) default 0,
QUEUEDURATION NUMBER(10) default 0,
VMDURATION NUMBER(10) default 0,
WMRECDURATION NUMBER(10) default 0,
HOLDDURATION NUMBER(10) default 0,
TALKDURATION NUMBER(10) default 0,
RECORDDURATION NUMBER(10) default 0,
ANSWERWITHINSLT NUMBER(1) default 0,
EXITSTATE NUMBER not null,
ABNTARGETTYPE NUMBER(1) default 0,
ADVQAPPTYPE NUMBER(10) default 0,
MMCALLTYPE NUMBER(10) default 0,
PRIORITYQUEUEDURATION NUMBER(10) default 0,
IVREXITPOINT VARCHAR2(63),
IVRDATA VARCHAR2(255),
URLDATA VARCHAR2(255),
FROMDATA VARCHAR2(255),
USERDATA VARCHAR2(255),
SID NUMBER(10) default 0
)
tablespace RWCM_TEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 577M
minextents 1
maxextents unlimited
);
-- Create/Recreate indexes
create index CDRMAIN_OR_INDEX1 on CDRMAIN_OR (STARTTIME)
tablespace RWCM_TEST_INDEX
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 80M
minextents 1
maxextents unlimited
);
create index CDRMAIN_OR_INDEX2 on CDRMAIN_OR (ENDTIME)
tablespace RWCM_TEST_INDEX
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 80M
minextents 1
maxextents unlimited
);
create index CDRMAIN_OR_INDEX3 on CDRMAIN_OR (TALKDURATION)
tablespace RWCM_TEST_INDEX
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 61M
minextents 1
maxextents unlimited
);
create index CDRMAIN_OR_INDEX4 on CDRMAIN_OR (HOLDDURATION)
tablespace RWCM_TEST_INDEX
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 55M
minextents 1
maxextents unlimited
);
create index PRI_CDRMAIN_OR on CDRMAIN_OR (NODEID, ENDTIME, SESSIONID, LOCALDAY, SEQUENCEID)
tablespace RWCM_TEST_INDEX
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 168M
minextents 1
maxextents unlimited
);