Oracle Error Message
ORA-42018: partition cannot be redefined online because of index organization incompatibility
Reason for 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 not
– one has IOT overflow segment and the other does not
– one has IOT mapping table and the other does not
Solution
Ensure that the interim table is compatible with the partition being redefined.
