河南的脚本不能用,就自己建立的这个脚本
CREATE TABLE ODS_CDR_GSM
(
ACCT_MONTH VARCHAR2(8),
CDR_ZONE VARCHAR2(10),
SUB_LOCAL_NET VARCHAR2(6),
USER_NO VARCHAR2(20),
MOBILE_NUMBER VARCHAR2(15),
OPPOSE_AREA_CODE VARCHAR2(10),
OPPOSE_NUMBER VARCHAR2(25),
OPPOSE_DEALER_CODE VARCHAR2(10),
CALL_TRANSFER VARCHAR2(6),
CELLID VARCHAR2(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_MONTH )
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 INITRANS 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 INITRANS 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,
SUBPARTITION ODS_CDR_GSM_8_200502 TABLESPACE EBA_DATA),
PARTITION ODS_CDR_GSM_200503 VALUES LESS THAN ('200504') PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE EBA_DATA LOGGING
(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 INITRANS 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 ('200508') 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 INITRANS 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 INITRANS 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 INITRANS 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)
);
CREATE TABLE ODS_CDR_GSM
(
ACCT_MONTH VARCHAR2(8),
CDR_ZONE VARCHAR2(10),
SUB_LOCAL_NET VARCHAR2(6),
USER_NO VARCHAR2(20),
MOBILE_NUMBER VARCHAR2(15),
OPPOSE_AREA_CODE VARCHAR2(10),
OPPOSE_NUMBER VARCHAR2(25),
OPPOSE_DEALER_CODE VARCHAR2(10),
CALL_TRANSFER VARCHAR2(6),
CELLID VARCHAR2(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_MONTH )
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 INITRANS 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 INITRANS 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,
SUBPARTITION ODS_CDR_GSM_8_200502 TABLESPACE EBA_DATA),
PARTITION ODS_CDR_GSM_200503 VALUES LESS THAN ('200504') PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE EBA_DATA LOGGING
(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 INITRANS 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 ('200508') 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 INITRANS 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 INITRANS 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 INITRANS 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)
);