Online Partition Move fails with ORA-00932 – 12.1.0.2

Oracle 12c introduced feature to move table partitions and sub-partitions as online operations.So, this blog is related to this feature and the issue I faced. The database was upgraded from 11.2.0.4 to 12.1.0.2 and this issue is seen in upgraded databases only. Lets start!!! SQL> create table sales_part (product char(25),channel_id number,cust_id number, amount_sold number, time_id …

Advertisement