Load Ingest Data
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Oracle CDC in Sql Server 2012

  1. #1
    alvinr is offline Junior Member
    Join Date
    Mar 2012
    Posts
    12
    Rep Power
    0

    Oracle CDC in Sql Server 2012

    If the table is partitioned in Oracle, CDC does not work. If I recreate the table as a non partitioned table it works. I don't kow if this is bug or I need to do something else in the designer to make it work?

    I filed a bug on Microsoft Connect site last week.

    Ron

  2. #2
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Hi Ron,

    What do you mean by CDC does not work? Do you get an error or the changes are not captured?

    Please reproduce the issue and then use the Collect Diagnostics link from the Designer status tab to create a file with the trace table contents and attach the log file.

    If possible, then add also the create table script.


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    alvinr is offline Junior Member
    Join Date
    Mar 2012
    Posts
    12
    Rep Power
    0
    No errors but changes are not replicated. Its easy to recreate, just create a table in Oracle that's partitioned and try CDC. It sees the changes but it can't apply them at the target location.

    DDL:
    CREATE TABLE "XTRA"."CMPL_CUST_FOLDER"
    (
    "FOLDER_ID" NUMBER,
    "DEALER_ID" VARCHAR2(20 BYTE),
    "OVERALL_STATUS" VARCHAR2(1 BYTE),
    "IDEFEND_STATUS" VARCHAR2(1 BYTE),
    "CREDIT_STATUS" VARCHAR2(1 BYTE),
    "ECON_STATUS" VARCHAR2(1 BYTE),
    "EMENU_STATUS" VARCHAR2(1 BYTE),
    "SSN" VARCHAR2(50 BYTE),
    "FIRST_NAME" VARCHAR2(15 BYTE),
    "MI" VARCHAR2(1 BYTE),
    "LAST_NAME" VARCHAR2(35 BYTE),
    "CO_SSN" VARCHAR2(50 BYTE),
    "CO_FIRST_NAME" VARCHAR2(15 BYTE),
    "CO_MI" VARCHAR2(1 BYTE),
    "CO_LAST_NAME" VARCHAR2(35 BYTE),
    "CREATED_DATE" DATE DEFAULT SYSDATE,
    "CREATED_BY_LAST_NAME" VARCHAR2(25 BYTE),
    "CREATED_BY_FIRST_NAME" VARCHAR2(15 BYTE),
    "MODIFIED_DATE" DATE DEFAULT SYSDATE,
    "MODIFIED_BY_LAST_NAME" VARCHAR2(25 BYTE),
    "MODIFIED_BY_FIRST_NAME" VARCHAR2(15 BYTE),
    "AA_STATUS" VARCHAR2(1 BYTE),
    "CCID" VARCHAR2(15 BYTE),
    "VEHICLE_YEAR" VARCHAR2(4 BYTE),
    "VEHICLE_MAKE" VARCHAR2(20 BYTE),
    "VEHICLE_MODEL" VARCHAR2(35 BYTE),
    "VEHICLE_TRIM" VARCHAR2(50 BYTE),
    "VEHICLE_STATUS" VARCHAR2(1 BYTE),
    "COCCID" VARCHAR2(15 BYTE),
    CONSTRAINT "PK_CMPL_CUST_FOLDER_FID" PRIMARY KEY ("FOLDER_ID") USING INDEX PCTFREE 10 INITRANS 6 MAXTRANS 255 NOLOGGING COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_INDX" ENABLE,
    SUPPLEMENTAL LOG GROUP "ATTU_55C173D8_gr0" ("FOLDER_ID", "DEALER_ID", "OVERALL_STATUS", "IDEFEND_STATUS", "CREDIT_STATUS", "ECON_STATUS", "EMENU_STATUS", "SSN", "FIRST_NAME", "MI", "LAST_NAME", "CO_SSN", "CO_FIRST_NAME", "CO_MI", "CO_LAST_NAME", "CREATED_DATE", "CREATED_BY_LAST_NAME", "CREATED_BY_FIRST_NAME", "MODIFIED_DATE", "MODIFIED_BY_LAST_NAME", "MODIFIED_BY_FIRST_NAME", "AA_STATUS", "CCID", "VEHICLE_YEAR", "VEHICLE_MAKE", "VEHICLE_MODEL", "VEHICLE_TRIM", "VEHICLE_STATUS", "COCCID") ALWAYS
    )
    PCTFREE 20 PCTUSED 70 INITRANS 10 MAXTRANS 255 LOGGING STORAGE
    (
    MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT
    )
    TABLESPACE "CMPL_DATA" PARTITION BY RANGE
    (
    "CREATED_DATE"
    )
    (
    PARTITION "CUST_FOLDER_200512" VALUES LESS THAN (TO_DATE(' 2006-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200601" VALUES LESS THAN (TO_DATE(' 2006-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200602" VALUES LESS THAN (TO_DATE(' 2006-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200603" VALUES LESS THAN (TO_DATE(' 2006-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200604" VALUES LESS THAN (TO_DATE(' 2006-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200605" VALUES LESS THAN (TO_DATE(' 2006-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200606" VALUES LESS THAN (TO_DATE(' 2006-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200607" VALUES LESS THAN (TO_DATE(' 2006-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200608" VALUES LESS THAN (TO_DATE(' 2006-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200609" VALUES LESS THAN (TO_DATE(' 2006-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200610" VALUES LESS THAN (TO_DATE(' 2006-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200611" VALUES LESS THAN (TO_DATE(' 2006-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200612" VALUES LESS THAN (TO_DATE(' 2007-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200701" VALUES LESS THAN (TO_DATE(' 2007-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200702" VALUES LESS THAN (TO_DATE(' 2007-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200703" VALUES LESS THAN (TO_DATE(' 2007-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200704" VALUES LESS THAN (TO_DATE(' 2007-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200705" VALUES LESS THAN (TO_DATE(' 2007-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200706" VALUES LESS THAN (TO_DATE(' 2007-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200707" VALUES LESS THAN (TO_DATE(' 2007-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200708" VALUES LESS THAN (TO_DATE(' 2007-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200709" VALUES LESS THAN (TO_DATE(' 2007-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200710" VALUES LESS THAN (TO_DATE(' 2007-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200711" VALUES LESS THAN (TO_DATE(' 2007-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200712" VALUES LESS THAN (TO_DATE(' 2008-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200801" VALUES LESS THAN (TO_DATE(' 2008-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200802" VALUES LESS THAN (TO_DATE(' 2008-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200803" VALUES LESS THAN (TO_DATE(' 2008-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200804" VALUES LESS THAN (TO_DATE(' 2008-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200805" VALUES LESS THAN (TO_DATE(' 2008-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200806" VALUES LESS THAN (TO_DATE(' 2008-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200807" VALUES LESS THAN (TO_DATE(' 2008-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200808" VALUES LESS THAN (TO_DATE(' 2008-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200809" VALUES LESS THAN (TO_DATE(' 2008-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200810" VALUES LESS THAN (TO_DATE(' 2008-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200811" VALUES LESS THAN (TO_DATE(' 2008-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200812" VALUES LESS THAN (TO_DATE(' 2009-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200901" VALUES LESS THAN (TO_DATE(' 2009-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200902" VALUES LESS THAN (TO_DATE(' 2009-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200903" VALUES LESS THAN (TO_DATE(' 2009-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200904" VALUES LESS THAN (TO_DATE(' 2009-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200905" VALUES LESS THAN (TO_DATE(' 2009-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200906" VALUES LESS THAN (TO_DATE(' 2009-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200907" VALUES LESS THAN (TO_DATE(' 2009-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200908" VALUES LESS THAN (TO_DATE(' 2009-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200909" VALUES LESS THAN (TO_DATE(' 2009-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200910" VALUES LESS THAN (TO_DATE(' 2009-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200911" VALUES LESS THAN (TO_DATE(' 2009-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_200912" VALUES LESS THAN (TO_DATE(' 2010-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201001" VALUES LESS THAN (TO_DATE(' 2010-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201002" VALUES LESS THAN (TO_DATE(' 2010-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201003" VALUES LESS THAN (TO_DATE(' 2010-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201004" VALUES LESS THAN (TO_DATE(' 2010-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201005" VALUES LESS THAN (TO_DATE(' 2010-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201006" VALUES LESS THAN (TO_DATE(' 2010-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201007" VALUES LESS THAN (TO_DATE(' 2010-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201008" VALUES LESS THAN (TO_DATE(' 2010-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201009" VALUES LESS THAN (TO_DATE(' 2010-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201010" VALUES LESS THAN (TO_DATE(' 2010-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201011" VALUES LESS THAN (TO_DATE(' 2010-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201012" VALUES LESS THAN (TO_DATE(' 2011-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201101" VALUES LESS THAN (TO_DATE(' 2011-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201102" VALUES LESS THAN (TO_DATE(' 2011-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201103" VALUES LESS THAN (TO_DATE(' 2011-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201104" VALUES LESS THAN (TO_DATE(' 2011-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201105" VALUES LESS THAN (TO_DATE(' 2011-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201106" VALUES LESS THAN (TO_DATE(' 2011-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201107" VALUES LESS THAN (TO_DATE(' 2011-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201108" VALUES LESS THAN (TO_DATE(' 2011-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201109" VALUES LESS THAN (TO_DATE(' 2011-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201110" VALUES LESS THAN (TO_DATE(' 2011-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201111" VALUES LESS THAN (TO_DATE(' 2011-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201112" VALUES LESS THAN (TO_DATE(' 2012-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201201" VALUES LESS THAN (TO_DATE(' 2012-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201202" VALUES LESS THAN (TO_DATE(' 2012-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 6 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201203" VALUES LESS THAN (TO_DATE(' 2012-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 24 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201204" VALUES LESS THAN (TO_DATE(' 2012-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 24 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201205" VALUES LESS THAN (TO_DATE(' 2012-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 24 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201206" VALUES LESS THAN (TO_DATE(' 2012-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 24 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201207" VALUES LESS THAN (TO_DATE(' 2012-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 24 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201208" VALUES LESS THAN (TO_DATE(' 2012-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 24 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201209" VALUES LESS THAN (TO_DATE(' 2012-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 24 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201210" VALUES LESS THAN (TO_DATE(' 2012-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 24 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201211" VALUES LESS THAN (TO_DATE(' 2012-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 24 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201212" VALUES LESS THAN (TO_DATE(' 2013-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 24 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201301" VALUES LESS THAN (TO_DATE(' 2013-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 24 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS ,
    PARTITION "CUST_FOLDER_201302" VALUES LESS THAN (TO_DATE(' 2013-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 20 PCTUSED 70 INITRANS 24 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 6 FREELIST GROUPS 2 BUFFER_POOL DEFAULT) TABLESPACE "CMPL_DATA" NOCOMPRESS
    )
    PARALLEL 3 ;
    COMMENT ON TABLE "XTRA"."CMPL_CUST_FOLDER"
    IS
    '
    rows : 1 or more lender decision per contract per lender
    insert : Yes
    update : No
    delete : No
    lookup : No
    structure : likely to change
    description: Table CMPL_CUST_FOLDER holds one records per lender decision on a contract
    data required to be staged for 9 years.
    ';
    Last edited by alvinr; 04-10-2012 at 10:41 PM.

  4. #4
    JasonH is offline Junior Member
    Join Date
    Mar 2012
    Posts
    4
    Rep Power
    0
    Can you please share the connect item number, or URL?

    Thanks, Jason

  5. #5
    alvinr is offline Junior Member
    Join Date
    Mar 2012
    Posts
    12
    Rep Power
    0
    What is the 'connect item number'?

  6. #6
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    The bug number or URL you filed on Microsoft Connect site.

    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  7. #7
    alvinr is offline Junior Member
    Join Date
    Mar 2012
    Posts
    12
    Rep Power
    0

  8. #8
    alvinr is offline Junior Member
    Join Date
    Mar 2012
    Posts
    12
    Rep Power
    0
    Were you guys able to reproduce the issue?
    This is stopping me from doing any DEV\QA migration to sql 2012. I currently use the attunity ssis 2008 Oracle CDC connector but I can't upgrade to sql 2012 until I can work thru this CDC issue. CDC from Oracle is very important to me.

    Thanks.

  9. #9
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Hi Ron,

    We have the repro and are actively working on a fix. We’ll let you know as soon as its available.


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  10. #10
    alvinr is offline Junior Member
    Join Date
    Mar 2012
    Posts
    12
    Rep Power
    0
    Quote Originally Posted by Gadi.Farhat View Post
    Hi Ron,

    We have the repro and are actively working on a fix. We’ll let you know as soon as its available.


    Regards,

    Gadi
    Any eta on when the fix will be available...
    Thanks.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •