No, I am not talking about DBMS_REDEFINITION, where you get a kind of online feeling.
No, I don’t want to rename my table, rename my foreign keys, my primary key, my not-null-constraints, recreate my referential integrity, recompile my triggers.
I just want to partition a non-partitioned table.
ALTER TABLE EMP MODIFY PARTITION BY RANGE(HIREDATE) INTERVAL(NUMTOYMINTERVAL(1, 'MONTH')) (PARTITION P1 VALUES LESS THAN (DATE '1980-01-01')) ONLINE;
This is going to save me a lot of Saturday work 🙂
You need 12.2 to run this.