-------------------------------------------------------- Current DAY_TABLES definition -------------------------------------------------------- CREATE TABLE "CDR"."DAY_TABLES" ( "RECORDCODE" VARCHAR2(1 BYTE), "CDRSTART" DATE, "CDREND" DATE, "DURATION" NUMBER, "SWITCHTSN" VARCHAR2(3 BYTE), "ORIGTRUNK" VARCHAR2(8 BYTE), "ORIGTRUNKTYPE" VARCHAR2(4 BYTE), "ORIGTRUNKNUM" NUMBER, "TERMTRUNK" VARCHAR2(8 BYTE), "TERMTRUNKTYPE" VARCHAR2(4 BYTE), "TERMTRUNKNUM" NUMBER, "ANUMBER" VARCHAR2(20 BYTE), "BILLTYPE" VARCHAR2(1 BYTE), "BNUMBER" VARCHAR2(20 BYTE), "TREATMENTCODE" NUMBER, "COMPLETIONCODE" NUMBER, "ANSDET" VARCHAR2(1 BYTE), "SEQUENCENUM" NUMBER, "CNUMBER" VARCHAR2(20 BYTE) ) PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE TABLESPACE "CDR_DATA" PARTITION BY RANGE ("CDRSTART") (PARTITION "JDAY_180_00_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 01:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_01_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 02:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_02_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 03:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_03_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 04:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_04_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 05:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_05_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 06:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_06_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 07:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_07_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 08:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_07_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 08:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_07_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 08:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_07_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 08:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_08_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 09:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_08_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 09:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_08_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 09:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_08_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 09:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_09_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 10:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_09_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 10:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_09_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 10:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_09_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 10:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_10_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 11:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_10_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 11:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_10_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 11:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_10_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 11:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_11_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 12:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_11_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 12:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_11_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 12:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_11_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 12:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_12_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 13:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_12_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 13:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_12_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 13:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_12_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 13:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_13_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 14:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_13_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 14:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_13_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 14:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_13_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 14:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_14_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 15:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_14_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 15:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_14_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 15:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_14_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 15:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_15_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 16:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_15_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 16:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_15_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 16:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_15_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 16:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_16_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 17:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_16_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 17:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_16_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 17:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_16_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 17:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_17_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 18:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_17_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 18:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_17_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 18:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_17_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 18:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_18_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 19:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_18_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 19:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_19_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 20:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_19_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 20:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_20_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 21:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_20_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 21:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_21_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 22:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_22_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 23:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" , PARTITION "JDAY_180_23_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 23:59:59', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ) ; -------------------------------------------------------- -- Constraints for Table DAY_TABLES -------------------------------------------------------- ALTER TABLE "CDR"."DAY_TABLES" MODIFY ("SEQUENCENUM" NOT NULL ENABLE); ALTER TABLE "CDR"."DAY_TABLES" MODIFY ("SWITCHTSN" NOT NULL ENABLE); ALTER TABLE "CDR"."DAY_TABLES" MODIFY ("CDREND" NOT NULL ENABLE); ALTER TABLE "CDR"."DAY_TABLES" MODIFY ("CDRSTART" NOT NULL ENABLE); ALTER TABLE "CDR"."DAY_TABLES" MODIFY ("RECORDCODE" NOT NULL ENABLE); -------------------------------------------------------- New DAY_TABLES definition -------------------------------------------------------- CREATE TABLE "CDR"."DAY_TABLES_2" ( "RECORDCODE" VARCHAR2(1 BYTE), "CDRSTART" DATE, "CDREND" DATE, "DURATION" NUMBER, "SWITCHTSN" VARCHAR2(3 BYTE), "ORIGTRUNK" VARCHAR2(8 BYTE), "ORIGTRUNKTYPE" VARCHAR2(4 BYTE), "ORIGTRUNKNUM" NUMBER, "TERMTRUNK" VARCHAR2(8 BYTE), "TERMTRUNKTYPE" VARCHAR2(4 BYTE), "TERMTRUNKNUM" NUMBER, "ANUMBER" VARCHAR2(20 BYTE), "BILLTYPE" VARCHAR2(1 BYTE), "BNUMBER" VARCHAR2(20 BYTE), "TREATMENTCODE" NUMBER, "COMPLETIONCODE" NUMBER, "ANSDET" VARCHAR2(1 BYTE), "SEQUENCENUM" NUMBER, "CNUMBER" VARCHAR2(20 BYTE) ) PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE TABLESPACE "CDR_DATA" PARTITION BY RANGE ("CDRSTART") SUBPARTITION BY HASH ("ANUMBER") SUBPARTITIONS 6 (PARTITION "JDAY_180_00_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 01:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96741" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96742" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96743" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96744" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96745" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96746" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_01_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 02:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96747" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96748" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96749" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96750" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96751" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96752" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_02_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 03:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96753" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96754" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96755" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96756" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96757" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96758" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_03_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 04:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96759" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96760" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96761" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96762" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96763" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96764" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_04_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 05:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96765" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96766" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96767" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96768" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96769" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96770" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_05_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 06:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96771" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96772" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96773" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96774" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96775" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96776" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_06_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 07:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96777" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96778" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96779" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96780" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96781" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96782" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_07_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 08:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96783" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96784" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96785" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96786" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96787" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96788" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_07_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 08:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96789" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96790" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96791" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96792" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96793" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96794" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_07_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 08:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96795" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96796" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96797" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96798" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96799" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96800" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_07_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 08:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96801" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96802" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96803" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96804" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96805" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96806" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_08_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 09:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96807" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96808" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96809" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96810" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96811" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96812" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_08_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 09:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96813" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96814" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96815" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96816" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96817" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96818" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_08_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 09:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96819" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96820" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96821" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96822" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96823" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96824" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_08_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 09:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96825" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96826" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96827" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96828" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96829" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96830" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_09_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 10:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96831" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96832" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96833" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96834" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96835" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96836" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_09_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 10:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96837" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96838" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96839" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96840" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96841" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96842" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_09_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 10:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96843" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96844" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96845" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96846" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96847" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96848" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_09_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 10:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96849" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96850" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96851" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96852" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96853" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96854" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_10_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 11:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96855" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96856" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96857" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96858" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96859" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96860" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_10_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 11:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96861" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96862" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96863" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96864" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96865" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96866" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_10_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 11:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96867" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96868" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96869" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96870" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96871" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96872" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_10_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 11:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96873" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96874" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96875" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96876" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96877" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96878" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_11_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 12:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96879" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96880" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96881" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96882" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96883" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96884" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_11_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 12:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96885" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96886" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96887" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96888" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96889" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96890" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_11_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 12:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96891" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96892" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96893" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96894" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96895" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96896" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_11_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 12:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96897" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96898" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96899" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96900" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96901" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96902" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_12_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 13:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96903" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96904" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96905" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96906" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96907" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96908" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_12_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 13:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96909" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96910" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96911" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96912" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96913" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96914" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_12_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 13:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96915" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96916" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96917" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96918" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96919" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96920" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_12_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 13:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96921" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96922" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96923" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96924" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96925" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96926" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_13_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 14:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96927" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96928" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96929" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96930" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96931" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96932" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_13_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 14:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96933" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96934" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96935" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96936" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96937" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96938" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_13_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 14:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96939" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96940" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96941" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96942" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96943" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96944" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_13_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 14:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96945" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96946" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96947" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96948" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96949" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96950" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_14_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 15:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96951" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96952" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96953" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96954" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96955" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96956" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_14_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 15:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96957" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96958" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96959" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96960" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96961" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96962" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_14_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 15:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96963" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96964" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96965" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96966" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96967" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96968" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_14_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 15:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96969" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96970" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96971" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96972" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96973" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96974" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_15_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 16:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96975" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96976" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96977" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96978" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96979" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96980" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_15_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 16:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96981" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96982" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96983" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96984" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96985" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96986" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_15_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 16:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96987" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96988" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96989" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96990" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96991" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96992" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_15_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 16:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96993" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96994" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96995" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96996" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96997" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP96998" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_16_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 17:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP96999" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97000" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97001" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97002" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97003" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97004" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_16_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 17:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97005" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97006" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97007" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97008" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97009" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97010" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_16_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 17:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97011" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97012" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97013" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97014" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97015" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97016" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_16_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 17:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97017" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97018" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97019" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97020" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97021" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97022" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_17_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 18:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97023" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97024" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97025" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97026" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97027" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97028" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_17_15" VALUES LESS THAN (TO_DATE(' 2017-06-29 18:15:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97029" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97030" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97031" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97032" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97033" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97034" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_17_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 18:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97035" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97036" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97037" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97038" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97039" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97040" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_17_45" VALUES LESS THAN (TO_DATE(' 2017-06-29 18:45:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97041" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97042" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97043" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97044" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97045" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97046" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_18_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 19:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97047" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97048" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97049" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97050" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97051" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97052" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_18_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 19:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97053" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97054" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97055" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97056" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97057" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97058" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_19_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 20:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97059" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97060" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97061" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97062" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97063" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97064" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_19_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 20:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97065" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97066" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97067" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97068" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97069" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97070" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_20_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 21:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97071" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97072" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97073" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97074" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97075" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97076" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_20_30" VALUES LESS THAN (TO_DATE(' 2017-06-29 21:30:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97077" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97078" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97079" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97080" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97081" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97082" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_21_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 22:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97083" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97084" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97085" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97086" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97087" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97088" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_22_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 23:00:00', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97089" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97090" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97091" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97092" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97093" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97094" TABLESPACE "CDR_DATA") , PARTITION "JDAY_180_23_00" VALUES LESS THAN (TO_DATE(' 2017-06-29 23:59:59', 'SYYYY-MM-DD HH24:MI:SS')) TABLESPACE "CDR_DATA" ( SUBPARTITION "SYS_SUBP97095" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97096" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97097" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97098" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97099" TABLESPACE "CDR_DATA", SUBPARTITION "SYS_SUBP97100" TABLESPACE "CDR_DATA") ) ; -------------------------------------------------------- -- Constraints for Table DAY_TABLES -------------------------------------------------------- ALTER TABLE "CDR"."DAY_TABLES" MODIFY ("RECORDCODE" NOT NULL ENABLE); ALTER TABLE "CDR"."DAY_TABLES" MODIFY ("CDRSTART" NOT NULL ENABLE); ALTER TABLE "CDR"."DAY_TABLES" MODIFY ("CDREND" NOT NULL ENABLE); ALTER TABLE "CDR"."DAY_TABLES" MODIFY ("SWITCHTSN" NOT NULL ENABLE); ALTER TABLE "CDR"."DAY_TABLES" MODIFY ("SEQUENCENUM" NOT NULL ENABLE);