Database Administration (MOSC)

MOSC Banner

IOT and Hash Partition

edited Dec 16, 2012 7:23PM in Database Administration (MOSC) 3 commentsAnswered
  Hi,
    I have a very big Index organized table(IOT)  with 500 million rows and it is growing steadily.
It is also Hash Partitioned and the script is below.
CREATE TABLE TABLEX
(
  OBJECT_ID                 NUMBER(12),
  OBJECT_TYPE_ID            NUMBER(12)          NOT NULL,
  TRANSACTION_ID            NUMBER(12),
  TEMP_OBJ_ID        NUMBER(12),
  UTEMP_OBJ_ID       NUMBER(12),
  PERSIST_PARTITION_ID  NUMBER(12),
  PARENT_OBJECT_ID          NUMBER(12),
  CREATION_DATE             VARCHAR2(14 BYTE),
  LAST_UPDATED_DATE         VARCHAR2(14 BYTE),
  CONSTRAINT OBJECT_PK
  PRIMARY KEY
  (OBJECT_ID)
)
ORGANIZATION INDEX
  PARTITION BY HASH (OBJECT_ID)
  PARTITIONS 10
  STORE IN (OBJECT_DATA,OBJECT_DATA,OBJECT_DATA,OBJECT_DATA,OBJECT_DATA,OBJECT_DATA,OBJECT_DATA,OBJECT_DATA,OBJECT_DATA,OBJECT_DATA)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center