Hi,
I'm trying to partition an existing Indexed Organised Table by using the EXCHANGE PARTITION process:
1. CREATE DESTINATION TABLE
-----------------------------------------------------------------------------------------------
CREATE TABLE AUDIT_KNEW
(
AUDIT_ID CHAR(12 BYTE) NOT NULL,
ENV_ID NUMBER(6) NOT NULL,
CONSTRAINT XT506P0NEW
PRIMARY KEY
(AUDIT_ID, ENV_ID)
ENABLE VALIDATE
)
ORGANIZATION INDEX
PARTITION BY RANGE (AUDIT_ID)
(PARTITION PART_0 VALUES LESS THAN (MAXVALUE));
2.EXCHANGE PARTITION
-----------------------------------------------------------------------------------------------
ALTER TABLE AUDIT_KNEW
EXCHANGE PARTITION PART_0
WITH TABLE AUDIT_K
WITHOUT VALIDATION
UPDATE GLOBAL INDEXES;
4. DROP TABLE AND RENAME INDEXES
-----------------------------------------------------------------------------------------------
DROP TABLE AUDIT_K;
RENAME AUDIT_KNEW TO AUDIT_K;
ALTER INDEX XT506P0NEW RENAME TO XT506P0;
5. SPLIT PARTITIONS
-----------------------------------------------------------------------------------------------
ALTER TABLE AUDIT_K SPLIT PARTITION PART_0 INTO
( PARTITION PART_1 VALUES LESS THAN (112499999999),
PARTITION PART_2 VALUES LESS THAN (124999999999),
PARTITION PART_3 VALUES LESS THAN (137499999999),
PARTITION PART_4 VALUES LESS THAN (149999999999),
PARTITION PART_5 VALUES LESS THAN (162499999999),
PARTITION PART_6 VALUES LESS THAN (174499999999),
PARTITION PART_7 VALUES LESS THAN (187499999999),
PARTITION PART_8)
UPDATE GLOBAL INDEXES;
However, when i get to the final step of splitting the partition into multiple partitions, i get the following error:
Quote:
ERROR at line 1:
ORA-14046: a partition may be split into exactly two new partitions
I have split a partition into multiple partitions before using the code above, but i'm not sure why it hasn't worked on this particular table. maybe because it's an IOT? Am i missing a step?
Thanks in advance,
Zaff