5 Replies Latest reply: Apr 8, 2013 3:57 AM by DecaXD RSS

    How to avoid Journal Table Partition?

    RK Chithamalai
      Hi Gurus,

      The Journal Tables are getting created with partitions. Is there any way we can avoid partition, we don't want to create these journal tables with partitions? We are using ODI 10.1.3.

      Attached one of the journal table created.

      CREATE TABLE EBS_ODI_TMP.J$JTF_TASKS_B
      (
      OPERATION$ CHAR(2 BYTE),
      CSCN$ NUMBER,
      COMMIT_TIMESTAMP$ DATE,
      TIMESTAMP$ DATE,
      TASK_ID NUMBER
      )
      TABLESPACE EBS_ODI_TMP_DATA
      PCTUSED 0
      PCTFREE 10
      INITRANS 1
      MAXTRANS 255
      STORAGE (
      BUFFER_POOL DEFAULT
      )
      PARTITION BY RANGE (CSCN$)
      (
      Partition P1 VALUES LESS THAN (281474976710656)
      LOGGING
      NOCOMPRESS
      TABLESPACE EBS_ODI_TMP_DATA
      PCTFREE 10
      INITRANS 1
      MAXTRANS 255
      STORAGE (
      INITIAL 64K
      MINEXTENTS 1
      MAXEXTENTS UNLIMITED
      BUFFER_POOL DEFAULT
      )
      )
      NOCOMPRESS
      NOCACHE
      NOPARALLEL
      MONITORING;

      Thanks
      RK