IOT and Hash Partition
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)
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)
0