huawei--创建表，用表分区、表空间、索引、主见

DROP TABLE TBILLLOG1 CASCADE CONSTRAINTS
CREATE TABLE TBILLLOG1
(
  PARTID NUMBER(2) ,
  CALLID VARCHAR2(25) NOT NULL,
  CALLIDNUM NUMBER(4),  
  CALLBEGIN DATE,  
  CALLEND DATE NOT NULL ,  
  UVID NUMBER(10) NOT NULL,  
  UserType NUMBER(4),  
  SkillID NUMBER(10) NULL
 )  
partition by list (PARTID)
(  
  partition P01 values(1)
  tablespace ICD_BILLLOG1
  pctfree 10
  pctused 80
  initrans 1
  maxtrans 255
  storage
  (
  initial 128k
  next 128k
  minextents 1
  maxextents unlimited
  pctincrease 0
  ), 
  -- ........
  partition P29 values(29)
  tablespace ICD_BILLLOG1
  pctfree 10
  pctused 80
  initrans 1
  maxtrans 255
  storage
  (
  initial 128k
  next 128k
  minextents 1
  maxextents unlimited
  pctincrease 0
  ), 
  partition P30 values(30)
  tablespace ICD_BILLLOG1
  pctfree 10
  pctused 80
  initrans 1
  maxtrans 255
  storage
  (
  initial 128k
  next 128k
  minextents 1
  maxextents unlimited
  pctincrease 0
  )
)
/
DROP TABLE tOprScoreDaily
CREATE TABLE tOprScoreDaily
(
  WorkDate date NOT NULL ,  
  CallTime NUMBER(14,2) NULL ,  
  SkillGroupID int NULL ,  
  SubCCNo int NOT NULL,
  MediaType number(2, 0) NOT NULL
)
TABLESPACE ICD_SERVICE
STORAGE
(
  INITIAL 1M
  NEXT 1M
  MINEXTENTS 1
  MAXEXTENTS 500
)
/
CREATE TABLE tOprScoreSettingTable1
(
  Transfercount_ComputeType number(5,0),
  SubCCNo number(6,0) NOT NULL,
  Ratio number(14,2),
  constraint PK_tOprScoreSettingTable1 Primary Key (ServiceType,SubCCNo,VDN,MediaType)
  using index tablespace ICD_SERVICE_IND
)
TABLESPACE ICD_SERVICE
/
CREATE TABLE tRecordInfo1(
  CALLID varchar2(25),  
  StopReason number(3)  
)
TABLESPACE ICD_BILLLOG1
  PCTFREE 10
  PCTUSED 85
  INITRANS 1
  MAXTRANS 255
  STORAGE(
  INITIAL 2M
  next 128k
  MINEXTENTS 1
  MAXEXTENTS 500
  PCTINCREASE 0
  FREELISTS 1
  FREELIST GROUPS 1)
/
DROP TABLE tAgentOprInfo CASCADE CONSTRAINTS
CREATE TABLE tAgentOprInfo(
  PartID CHAR(4) NOT NULL,  
  QueueID NUMBER(5) NOT NULL,  
  CallID VARCHAR2(25) ,  
  ActBegin DATE NOT NULL,  
  PHONENO VARCHAR2(26)  
)
TABLESPACE ICD_SERVICE
  PCTFREE 10
  PCTUSED 85
  INITRANS 1
  MAXTRANS 255
  STORAGE(INITIAL 5M
  NEXT 5M
  MINEXTENTS 1
  MAXEXTENTS 500
  PCTINCREASE 0
  FREELISTS 4
  FREELIST GROUPS 1)
PARTITION BY RANGE (PartID) (
PARTITION P01 VALUES LESS THAN ('0132') TABLESPACE ICD_SERVICE,
PARTITION P02 VALUES LESS THAN ('0232') TABLESPACE ICD_SERVICE,
PARTITION P03 VALUES LESS THAN ('0332') TABLESPACE ICD_SERVICE,
PARTITION P04 VALUES LESS THAN ('0432') TABLESPACE ICD_SERVICE,
PARTITION P05_1 VALUES LESS THAN ('0511') TABLESPACE ICD_SERVICE,
PARTITION P05_2 VALUES LESS THAN ('0521') TABLESPACE ICD_SERVICE,
PARTITION P05_3 VALUES LESS THAN ('0532') TABLESPACE ICD_SERVICE,
PARTITION P12_1 VALUES LESS THAN ('1221') TABLESPACE ICD_SERVICE,
PARTITION P12_2 VALUES LESS THAN ('1221') TABLESPACE ICD_SERVICE,
PARTITION P12_3 VALUES LESS THAN (MAXVALUE) TABLESPACE ICD_SERVICE
)
/