The script of Henan cannot be used, this script is established
CREATE TABLE ODS_CDR_GSM
(
ACCT_MONTH VARCHAR2 (8),
CDR_ZONE VARCHAR2 (10),
SUB_LOCAL_NET VARCHAR2 (6),
User_no varchar2 (20),
Mobile_number varcha2 (15),
Oppose_Area_code varchar2 (10),
Oppose_number varchar2 (25),
Oppose_dealer_code varchar2 (10),
Call_Transfer Varchar2 (6),
Cellid varcha2 (15),
ORG_TRM_ID VARCHAR2 (2),
ROAM_TYPE VARCHAR2 (4),
Call_type varchar2 (6),
IP_TYPE VARCHAR2 (6),
Service_code varchar2 (10),
Call_day varchar2 (10),
Call_Hour Varchar2 (10),
DEPT_NO VARCHAR2 (6),
User_dinner varchar2 (5),
CDR_NUMBER NUMBER,
Call_duration Number,
Mobile_times number,
Long_times number,
Basic_fee number,
ROAM_FEE NUMBER,
Long_fee number,
Other_fee number,
Basic_sfee number,
ROAM_SFEE NUMBER,
Long_sfee number,
Other_sfee number,
For_CNC Number,
For_Mob Number,
From_mob number,
Dura_Seg Varchar2 (6)
)
PCTFree 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 Logging TableSpace EBA_DATA Partition By Range (Acct_Mont)
Subpartition by hash (SUB_LOCAL_NET)
(
Partition ODS_CDR_GSM_200411 VALUES LESS THAN ('200412') PCTFree 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE EBA_DATA Logging
(Subpartition ODS_CDR_GSM_1_200411 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_2_200411 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_3_200411 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_4_200411 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_5_200411 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_6_200411 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_7_200411 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_8_200411 TableSpace EBA_DATA),
Partition ODS_CDR_GSM_200412 VALUES LESS THAN ('200501') PCTFree 10 PCTUSED 40 INITRENS 1 MAXTRANS 255 TABLESPACE EBA_DATA Logging (Subpartition ODS_CDR_GSM_1_200412 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_2_200412 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_3_200412 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_4_200412 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_5_200412 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_6_200412 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_7_200412 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_8_200412 TABLESPACE EBA_DATA),
Partition ODS_CDR_GSM_200501 VALUES LESS THAN ('200502') PCTFree 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE EBA_DATA Logging
(Subpartition ODS_CDR_GSM_1_200501 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_2_200501 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_3_200501 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_4_200501 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_5_200501 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_6_200501 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_7_200501 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_8_200501 TABLESPACE EBA_DATA,
Partition ODS_CDR_GSM_200502 VALUES LESS THAN ('200503') PCTFree 10 PCTUSED 40 IITRENS 1 MAXTRANS 255 TABLESPACE EBA_DATA Logging
(Subpartition ODS_CDR_GSM_1_200502 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_2_200502 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_3_200502 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_4_200502 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_5_200502 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_6_200502 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_7_200502 TableSpace EBA_DATA,
Subpha_8_200502 tablespace eba_data
(Subpartition ODS_CDR_GSM_1_200503 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_2_200503 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_3_200503 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_4_200503 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_5_200503 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_6_200503 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_7_200503 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_8_200503 TABLESPACE EBA_DATA),
Partition ODS_CDR_GSM_200504 VALUES LESS THAN ('200505') PCTFREE 10 PCTUSED 40 INITRENS 1 MAXTRANS 255 TABLESPACE EBA_DATA Logging
(Subpartition ODS_CDR_GSM_1_200504 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_2_200504 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_3_200504 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_4_200504 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_5_200504 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_6_200504 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_7_200504 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_8_200504 TABLESPACE EBA_DATA),
Partition ODS_CDR_GSM_200505 VALUES LESS THAN ('200506') PCTFree 10 Pctused 40 Initrans 1 MaxTrans 255 TableSpace EBA_DATA LOGGING
(Subpartition ODS_CDR_GSM_1_200505 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_2_200505 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_3_200505 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_4_200505 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_5_200505 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_6_200505 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_7_200505 TABLESPACE EBA_DATA, SUBPARTITION ODS_CDR_GSM_8_200505 TABLESPACE EBA_DATA),
Partition ODS_CDR_GSM_200506 VALUES LESS THAN ('200507') Pctfree 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE EBA_DATA Logging
(Subpartition ODS_CDR_GSM_1_200506 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_2_200506 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_3_200506 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_4_200506 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_5_200506 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_6_200506 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_7_200506 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_8_200506 TABLESPACE EBA_DATA,
Partition ODS_CDR_GSM_200507 VALUES LESS THAN ('20050 ") PCTFree 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE EBA_DATA Logging
(Subpartition ODS_CDR_GSM_1_200507 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_2_200507 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_3_200507 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_4_200507 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_5_200507 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_6_200507 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_7_200507 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_8_200507 TABLESPACE EBA_DATA),
Partition ODS_CDR_GSM_200508 VALUES LESS THAN ('200509') PCTFree 10 PCTUSED 40 IITRANS 1 MAXTRANS 255 TABLESPACE EBA_DATA Logging
(Subpartition ODS_CDR_GSM_1_200508 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_2_200508 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_3_200508 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_4_200508 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_5_200508 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_6_200508 TABLESPACE EBA_DATA, SUBPARTITION ODS_CDR_GSM_7_200508 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_8_200508 TABLESPACE EBA_DATA),
Partition ODS_CDR_GSM_200509 VALUES LESS THAN ('200510') PCTFree 10 PCTUSED 40 INITRENS 1 MAXTRANS 255 TABLESPACE EBA_DATA logging
(Subpartition ODS_CDR_GSM_1_200509 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_2_200509 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_3_200509 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_4_200509 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_5_200509 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_6_200509 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_7_200509 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_8_200509 TABLESPACE EBA_DATA),
Partition ODS_CDR_GSM_200510 VALUES LESS THAN ('200511') PCTFree 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE EBA_DATA logging
(Subpartition ODS_CDR_GSM_1_200510 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_2_200510 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_3_200510 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_4_200510 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_5_200510 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_6_200510 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_7_200510 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_8_200510 TABLESPACE EBA_DATA,
Partition ODS_CDR_GSM_200511 Values Less Than ('200512') PCTFree 10 PCTUSED 40 INITRENS 1 MAXTRANS 255 TABLESPACE EBA_DATA Logging
(Subpartition ODS_CDR_GSM_1_200511 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_2_200511 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_3_200511 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_4_200511 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_5_200511 TABLESPACE EBA_DATA, SUBPARTITION ODS_CDR_GSM_6_200511 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_7_200511 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_8_200511 TableSpace EBA_DATA),
Partition ODS_CDR_GSM_200512 VALUES LESS THAN ('200601') PCTFree 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE EBA_DATA Logging
(Subpartition ODS_CDR_GSM_1_200512 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_2_200512 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_3_200512 TABLESPACE EBA_DATA,
Subpartition ODS_CDR_GSM_4_200512 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_5_200512 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_6_200512 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_7_200512 TableSpace EBA_DATA,
Subpartition ODS_CDR_GSM_8_200512 TABLESPACE EBA_DATA)
);
