Oracle Error ORA-14075: partition maintenance operations may only be performed on partitioned indices

Oracle Error Message

ORA-14075: partition maintenance operations may only be performed on partitioned indices

Reason for the Error

Index named in ALTER INDEX partition maintenance operation is not partitioned, making a partition maintenance operation, at best, meaningless

Solution

Ensure that the index named in ALTER INDEX statement specifying a partition maintenance operation is, indeed, partitioned