Home » RDBMS Server » Server Administration » Partitioning existing Index Organised Table - [ORA-14046] (Oracle 12c)
Partitioning existing Index Organised Table - [ORA-14046] [message #649036] Thu, 10 March 2016 05:57
zaff
Messages: 50
Registered: July 2008
Member
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


Previous Topic: CPU 100% AND CUSTOMER APPLICATION SLOW
Next Topic: Running a query from 20 sessions concurrently
Goto Forum:
  


Current Time: Thu Mar 28 05:17:11 CDT 2024