Oracle Solution for Error ora-42018

Solution for Oracle 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.