-------------- Create table script -------------------------- CREATE TABLE RATED_CALL ( CALL_TYPE NUMBER(2), SERVICE_CODE VARCHAR2(3 BYTE), NE_CODE VARCHAR2(45 BYTE), IN_ROUTE VARCHAR2(30 BYTE), OUT_ROUTE VARCHAR2(30 BYTE), IMSI NUMBER(15), SGSN_ADDRESS VARCHAR2(45 BYTE), A_NUMBER VARCHAR2(25 BYTE), B_NUMBER VARCHAR2(25 BYTE), C_NUMBER VARCHAR2(25 BYTE), APN_ADDRESS VARCHAR2(65 BYTE), PDP_ADDRESS VARCHAR2(30 BYTE), CALL_DATE DATE, CALL_DURATION NUMBER(10), DATA_VOLUME_INC NUMBER(10), DATA_VOLUME_OUT NUMBER(10), TELESERVICE VARCHAR2(2 BYTE), BEARERSERVICE VARCHAR2(2 BYTE), CAMEL_FLAG VARCHAR2(1 BYTE), CAMEL_SERVICE_LEVEL NUMBER(6), CAMEL_SERVICE_KEY NUMBER(10), CAMEL_DEFAULT_CALL_HANDLING NUMBER(1), CAMEL_SERVER_ADDRESS VARCHAR2(24 BYTE), CAMEL_MSC_ADDRESS VARCHAR2(24 BYTE), CAMEL_CALL_REF_NUM VARCHAR2(16 BYTE), CAMEL_INIT_CF_INDICATOR NUMBER(1), CAMEL_DESTINATION_NUM VARCHAR2(24 BYTE), CAMEL_MODIFICATION VARCHAR2(4 BYTE), SUPPLIMENTARY_NUM VARCHAR2(2 BYTE), NETWORK_TIME NUMBER(4), REASON_FOR_CLEARDOWN NUMBER(4), PARTIAL_INDICATOR VARCHAR2(1 BYTE), PARTIAL_SEQ_NUM NUMBER(2), IMEI_NUM VARCHAR2(20 BYTE), CHRONO_NUM VARCHAR2(20 BYTE), CHARGING_ID NUMBER(10), SUBSCRIBER_TYPE VARCHAR2(1 BYTE), AGREEMENT_TYPE VARCHAR2(1 BYTE), PARTNER_CODE VARCHAR2(3 BYTE), CALL_DIRECTION VARCHAR2(1 BYTE), POI VARCHAR2(3 BYTE), ORIGIN_RATE_ZONE VARCHAR2(5 BYTE), DESTINATION_RATE_ZONE VARCHAR2(5 BYTE), DAY_CODE VARCHAR2(3 BYTE), TIME_TYPE VARCHAR2(3 BYTE), TARIFF_PLAN_CODE VARCHAR2(5 BYTE), TARIFF_ID NUMBER(6), UNIT_RATE NUMBER, CHARGEABLE_UNITS NUMBER(22,2), CHARGED_UNITS NUMBER(22,2), CHARGE_AMOUNT NUMBER, TAX_AMOUNT NUMBER, SUMMARY_SEQ_NO NUMBER, RATED_ON DATE, ADC NUMBER(10,4), STATUS VARCHAR2(15 BYTE) DEFAULT 'NEW', REPRICE_SEQ_NO NUMBER(10), NUMBER_PLAN_CODE VARCHAR2(5 BYTE), RATE_DIRECTION VARCHAR2(1 BYTE), PAYMENT_DIRECTION VARCHAR2(1 BYTE), INPUT_FILE_ID NUMBER(10) NOT NULL, RATE_UNIT VARCHAR2(1 BYTE), PARTNER_IDENTIFIER VARCHAR2(30 BYTE), ROAMING_STATUS VARCHAR2(1 BYTE) DEFAULT 'P', TEMP_SEQUENCE_NUMBER NUMBER(5), FILE_SEQUENCE_NUMBER NUMBER(5), CELL_ID VARCHAR2(20 BYTE), DATA_TYPE_INDICATOR VARCHAR2(1 BYTE), DISCOUNT_AMOUNT NUMBER DEFAULT 0, CHARGE_SDR NUMBER DEFAULT 0, DISCOUNT_SDR NUMBER DEFAULT 0, TAX_SDR NUMBER DEFAULT 0, CAMEL_FEE NUMBER DEFAULT 0, CAMEL_FEE_SDR NUMBER DEFAULT 0, CAMEL_TAX_AMOUNT NUMBER DEFAULT 0, CAMEL_TAX_SDR NUMBER DEFAULT 0, CAMEL_DISCOUNT_AMOUNT NUMBER DEFAULT 0, CAMEL_DISCOUNT_SDR NUMBER DEFAULT 0, DESTINATION_TYPE VARCHAR2(3 BYTE), DESTINATION_SUB_TYPE VARCHAR2(3 BYTE), RECORDING_ENTITY_TYPE NUMBER(2), CHARGE_TYPE VARCHAR2(2 BYTE), SERVICE_TYPE VARCHAR2(1 BYTE), ROAMING_ERROR_CODE VARCHAR2(15 BYTE), CALL_TYPE_LEVEL3 VARCHAR2(3 BYTE), HOME_EXCHANGE_RATE_CODE NUMBER(8) DEFAULT 0, TAP_EXCHANGE_RATE_CODE NUMBER(10) DEFAULT 0, EXCHANGE_RATE NUMBER(10), TAP_TAX_CODE NUMBER(1) DEFAULT 0, TAP_DISCOUNT_CODE NUMBER(1) DEFAULT 0, TAP_RECORDING_ENTITY_CODE NUMBER(2) DEFAULT 0, TAP_UTC_OFFSET_CODE NUMBER(2) DEFAULT 0, DISCOUNTABLE_AMOUNT NUMBER DEFAULT 0, DISCOUNTABLE_AMOUNT_SDR NUMBER DEFAULT 0, TOTAL_UNITS NUMBER, SUPPLIMENTARY_ACTION_CODE NUMBER(2), ORIGIN_DESTINATION_TYPE VARCHAR2(1 BYTE), DIALLED_DIGITS VARCHAR2(25 BYTE), RECORDING_ENTITY_TYPE_SGSN NUMBER(2), TAP_RECORDING_ENTITY_CODE_SGSN NUMBER(2) DEFAULT 0, DERIVED_SERVICE_CODE VARCHAR2(3 BYTE), CURRENCY_CODE VARCHAR2(3 BYTE), INVOICE_EVENT VARCHAR2(1 BYTE), RECORD_NO NUMBER(10), LCR_DESTINATION VARCHAR2(25 BYTE) ) PARTITION BY RANGE (CALL_DATE) ( PARTITION P20080301_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080302_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080303_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080304_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080305_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080306_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080307_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080308_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080309_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080310_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080311_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080312_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080313_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080314_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080315_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080316_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080317_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080318_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080319_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080320_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080321_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080322_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080323_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080324_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080325_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080326_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080327_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080328_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080329_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080330_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080331_CDRS VALUES LESS THAN (TO_DATE(' 2008-03-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080401_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080402_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080403_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080404_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080405_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080406_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080407_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080408_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080409_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080410_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080411_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080412_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080413_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080414_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080415_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080416_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080417_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080418_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080419_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080420_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080421_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080422_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080423_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080424_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080425_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080426_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080427_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080428_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080429_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080430_CDRS VALUES LESS THAN (TO_DATE(' 2008-04-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080501_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080502_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080503_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080504_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080505_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080506_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080507_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080508_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080509_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080510_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080511_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080512_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080513_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080514_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080515_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080516_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080517_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080518_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080519_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080520_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080521_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080522_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080523_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080524_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080525_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080526_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080527_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080528_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080529_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080530_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080531_CDRS VALUES LESS THAN (TO_DATE(' 2008-05-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080601_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080602_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080603_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080604_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080605_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080606_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080607_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080608_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080609_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080610_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080611_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080612_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080613_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080614_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080615_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080616_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080617_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080618_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080619_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080620_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080621_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080622_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080623_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080624_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080625_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080626_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080627_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080628_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080629_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080630_CDRS VALUES LESS THAN (TO_DATE(' 2008-06-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080701_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080702_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080703_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080704_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080705_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080706_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080707_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080708_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080709_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080710_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080711_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080712_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080713_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080714_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080715_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080716_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080717_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080718_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080719_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080720_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080721_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080722_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080723_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080724_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080725_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080726_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080727_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080728_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080729_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080730_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080731_CDRS VALUES LESS THAN (TO_DATE(' 2008-07-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080801_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080802_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080803_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080804_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080805_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080806_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080807_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080808_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080809_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080810_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080811_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080812_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080813_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080814_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080815_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080816_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080817_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080818_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080819_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080820_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080821_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080822_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080823_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080824_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080825_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080826_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080827_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080828_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080829_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080830_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS, PARTITION P20080831_CDRS VALUES LESS THAN (TO_DATE(' 2008-08-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS ) NOCOMPRESS NOCACHE NOPARALLEL MONITORING; CREATE INDEX RATED_CALL$REPRICE_SEQ_NO ON RATED_CALL (REPRICE_SEQ_NO) LOGGING NOPARALLEL; CREATE INDEX RATED_CALL$SUMMARY_SEQ_NO ON RATED_CALL (SUMMARY_SEQ_NO) LOGGING NOPARALLEL; CREATE INDEX RATED_CALL$FILE_ID ON RATED_CALL (INPUT_FILE_ID) LOGGING NOPARALLEL; CREATE UNIQUE INDEX RATED_CALL$UNIQUE_CDR ON RATED_CALL (CALL_DATE, PARTNER_CODE, CALL_DIRECTION, SERVICE_CODE, A_NUMBER, B_NUMBER, TIME_TYPE, AGREEMENT_TYPE) LOGGING NOPARALLEL; CREATE INDEX RATED_CALL$ROAM_CDRS ON RATED_CALL (AGREEMENT_TYPE, PARTNER_CODE, ROAMING_STATUS, DATA_TYPE_INDICATOR, FILE_SEQUENCE_NUMBER, CALL_DATE) LOGGING NOPARALLEL;