This discussion is archived
5 Replies Latest reply: Apr 8, 2013 1:57 AM by DecaXD RSS

How to avoid Journal Table Partition?

user640133 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points