list-hash 分区

  CREATE TABLE ADAPTER.ADAPTER_ERRORDATA

   ( EVENTID VARCHAR2(32) NOT NULL ENABLE,

 RECORDCLASSIFYING VARCHAR2(32),

 RECORDTITLE VARCHAR2(50),

 EFFECTIVETIME DATE,

 AUTHORORGANIZATION VARCHAR2(56),

 SOURCEID VARCHAR2(32),

 VERSIONNUMBER VARCHAR2(10),

 AUTHOR VARCHAR2(32),

 SYSTEMTIME DATE,

 UPLOADTIME DATE,

 HEADER VARCHAR2(4000),

 BODY BLOB,

 DOCFORMAT VARCHAR2(8),

 ZIPTYPE VARCHAR2(8),

 PROCESSFLAG VARCHAR2(1),

 ERRORCODE VARCHAR2(4),

 ERRORMSG CLOB,

 MSGFLAG VARCHAR2(1),

 RELATION VARCHAR2(200),

 ORIGINALBODY BLOB,

 CREATETIME DATE

   )

PARTITION BY LIST(RECORDCLASSIFYING)

SUBPARTITION BY HASH (AUTHORORGANIZATION)

SUBPARTITION TEMPLATE(

    SUBPARTITION Pb1 TABLESPACE ADAPTER_ERRORDATA_P1,

    SUBPARTITION Pb2 TABLESPACE ADAPTER_ERRORDATA_P2,

    SUBPARTITION Pb3 TABLESPACE ADAPTER_ERRORDATA_P3,

    SUBPARTITION Pb4 TABLESPACE ADAPTER_ERRORDATA_P4,

    SUBPARTITION Pb5 TABLESPACE ADAPTER_ERRORDATA_P5,

    SUBPARTITION Pb6 TABLESPACE ADAPTER_ERRORDATA_P6,

    SUBPARTITION Pb7 TABLESPACE ADAPTER_ERRORDATA_P7,

    SUBPARTITION Pb8 TABLESPACE ADAPTER_ERRORDATA_P8)

   

(

PARTITION P1 VALUES ('Cu_Register') TABLESPACE ADAPTER_ERRORDATA_P01,

PARTITION P2 VALUES ('Ipt_AdmissionNote') TABLESPACE ADAPTER_ERRORDATA_P02,

PARTITION P3 VALUES ('Ipt_AdviceDetail') TABLESPACE ADAPTER_ERRORDATA_P03,

PARTITION P4 VALUES ('Ipt_LeaveRecord') TABLESPACE ADAPTER_ERRORDATA_P04,

PARTITION P5 VALUES ('Ipt_MedicalRecordPage') TABLESPACE ADAPTER_ERRORDATA_P05,

PARTITION P6 VALUES ('Ipt_MedicalRecordPage_New') TABLESPACE ADAPTER_ERRORDATA_P06,

PARTITION P7 VALUES ('Ipt_Record') TABLESPACE ADAPTER_ERRORDATA_P07,

PARTITION P8 VALUES ('Ipt_SignsRecord') TABLESPACE ADAPTER_ERRORDATA_P08,

PARTITION P9 VALUES ('Opt_Fee') TABLESPACE ADAPTER_ERRORDATA_P09,

PARTITION P10 VALUES ('Opt_Recipe') TABLESPACE ADAPTER_ERRORDATA_P10,

PARTITION P11 VALUES ('Opt_Record') TABLESPACE ADAPTER_ERRORDATA_P11,

PARTITION P12 VALUES ('Opt_Register') TABLESPACE ADAPTER_ERRORDATA_P12,

PARTITION P13 VALUES ('Pt_Allergy') TABLESPACE ADAPTER_ERRORDATA_P13,

PARTITION P14 VALUES ('Pt_Diagnosis') TABLESPACE ADAPTER_ERRORDATA_P14,

PARTITION P15 VALUES ('Pt_ExamReport') TABLESPACE ADAPTER_ERRORDATA_P15,

PARTITION P16 VALUES ('Pt_LabReport') TABLESPACE ADAPTER_ERRORDATA_P16,

PARTITION P17 VALUES ('Pt_MedicineRely') TABLESPACE ADAPTER_ERRORDATA_P17,

PARTITION P18 VALUES ('Pt_Operation') TABLESPACE ADAPTER_ERRORDATA_P18,

PARTITION P19 VALUES ('Pt_Transfusion') TABLESPACE ADAPTER_ERRORDATA_P19,

PARTITION P20 VALUES ('Pt_Treatment') TABLESPACE ADAPTER_ERRORDATA_P20,

PARTITION P21 VALUES ('Pt_Treatment_D') TABLESPACE ADAPTER_ERRORDATA_P21,

PARTITION P22 VALUES ('Tj_ClinicFP') TABLESPACE ADAPTER_ERRORDATA_P22

);

  CREATE TABLE ADAPTER.ADAPTER_ORIGINALDATA

   ( EVENTID CHAR(32) NOT NULL ENABLE,

 RECORDCLASSIFYING VARCHAR2(32),

 RECORDTITLE VARCHAR2(50),

 EFFECTIVETIME DATE,

 AUTHORORGANIZATION VARCHAR2(56),

 SOURCEID VARCHAR2(32),

 VERSIONNUMBER VARCHAR2(10),

 AUTHOR VARCHAR2(32),

 SYSTEMTIME DATE,

 UPLOADTIME DATE,

 HEADER VARCHAR2(4000),

 BODY BLOB,

 DOCFORMAT VARCHAR2(8),

 ZIPTYPE VARCHAR2(8),

 PROCESSFLAG CHAR(1),

 ORIGINALBODY BLOB,

 MPIPROCESSFLAG CHAR(1),

 MPI VARCHAR2(32),

 DCID CHAR(16),

 CREATETIME DATE,

 AUTHORORGANIZATION_TEXT VARCHAR2(56)

 )

PARTITION BY LIST(RECORDCLASSIFYING)

SUBPARTITION BY HASH (AUTHORORGANIZATION)

SUBPARTITION TEMPLATE(

    SUBPARTITION Pa1 TABLESPACE ADAPTER_ORIGINALDATA_P1,

    SUBPARTITION Pa2 TABLESPACE ADAPTER_ORIGINALDATA_P2,

    SUBPARTITION Pa3 TABLESPACE ADAPTER_ORIGINALDATA_P3,

    SUBPARTITION Pa4 TABLESPACE ADAPTER_ORIGINALDATA_P4,

    SUBPARTITION Pa5 TABLESPACE ADAPTER_ORIGINALDATA_P5,

    SUBPARTITION Pa6 TABLESPACE ADAPTER_ORIGINALDATA_P6,

    SUBPARTITION Pa7 TABLESPACE ADAPTER_ORIGINALDATA_P7,

    SUBPARTITION Pa8 TABLESPACE ADAPTER_ORIGINALDATA_P8)

   

(

PARTITION P11 VALUES ('Cu_Register') TABLESPACE ADAPTER_ORIGINALDATA_P01,

PARTITION P12 VALUES ('Ipt_AdmissionNote') TABLESPACE ADAPTER_ORIGINALDATA_P02,

PARTITION P13 VALUES ('Ipt_AdviceDetail') TABLESPACE ADAPTER_ORIGINALDATA_P03,

PARTITION P14 VALUES ('Ipt_LeaveRecord') TABLESPACE ADAPTER_ORIGINALDATA_P04,

PARTITION P15 VALUES ('Ipt_MedicalRecordPage') TABLESPACE ADAPTER_ORIGINALDATA_P05,

PARTITION P16 VALUES ('Ipt_MedicalRecordPage_New') TABLESPACE ADAPTER_ORIGINALDATA_P06,

PARTITION P17 VALUES ('Ipt_Record') TABLESPACE ADAPTER_ORIGINALDATA_P07,

PARTITION P18 VALUES ('Ipt_SignsRecord') TABLESPACE ADAPTER_ORIGINALDATA_P08,

PARTITION P19 VALUES ('Opt_Fee') TABLESPACE ADAPTER_ORIGINALDATA_P09,

PARTITION P110 VALUES ('Opt_Recipe') TABLESPACE ADAPTER_ORIGINALDATA_P10,

PARTITION P111 VALUES ('Opt_Record') TABLESPACE ADAPTER_ORIGINALDATA_P11,

PARTITION P112 VALUES ('Opt_Register') TABLESPACE ADAPTER_ORIGINALDATA_P12,

PARTITION P113 VALUES ('Pt_Allergy') TABLESPACE ADAPTER_ORIGINALDATA_P13,

PARTITION P114 VALUES ('Pt_Diagnosis') TABLESPACE ADAPTER_ORIGINALDATA_P14,

PARTITION P115 VALUES ('Pt_ExamReport') TABLESPACE ADAPTER_ORIGINALDATA_P15,

PARTITION P116 VALUES ('Pt_LabReport') TABLESPACE ADAPTER_ORIGINALDATA_P16,

PARTITION P117 VALUES ('Pt_MedicineRely') TABLESPACE ADAPTER_ORIGINALDATA_P17,

PARTITION P118 VALUES ('Pt_Operation') TABLESPACE ADAPTER_ORIGINALDATA_P18,

PARTITION P119 VALUES ('Pt_Transfusion') TABLESPACE ADAPTER_ORIGINALDATA_P19,

PARTITION P120 VALUES ('Pt_Treatment') TABLESPACE ADAPTER_ORIGINALDATA_P20,

PARTITION P121 VALUES ('Pt_Treatment_D') TABLESPACE ADAPTER_ORIGINALDATA_P21,

PARTITION P122 VALUES ('Tj_ClinicFP') TABLESPACE ADAPTER_ORIGINALDATA_P22

);

   

   

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26764973/viewspace-1173634/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26764973/viewspace-1173634/