Oracle Solution for Error ora-42018
ORA-42018: partition cannot be redefined online because of index organization incompatibility
What triggered the Error:
interim table is incompatible with partition being redefined because one or more of the following apply:
*- one is index-organized and the other is no.
*- one has IOT overflow segment and the other does no.
*- one has IOT mapping table and the other does no.
What should we do to fix it:
Ensure that the interim table is compatible with the partition being redefined.