Converting Non-Partitioned Table to a Partitioned Table in Oracle Database 12c Release 2 (12.2)
Author : Gaurav Tewari Process is very much similar to earlier releases but now the same can be done online with no downtime, enabling concurrent DML operations while the conversion is ongoing & avoiding multiple steps like using redefinition or exchange partition per previous releases. Before proceeding be ready to confirm on limitations (restrictions) – This can't be used to partition an index-organized table (IOT). This can't be used if the table has a domain indexes. Can only convert a table to a reference-partitioned child table in offline mode. 1. Create the non-partitioned table: CREATE TABLE TEST1 ( id NUMBER, description VARCHAR2(50), created_date DATE, CONSTRAINT TEST1_pk PRIMARY KEY (id) ); 2. Create Index on column created_date: CREATE INDEX TEST1_creat...