Oracle Error ORA-14187: partitioning method for LOCAL index is inconsistent with that of the underlying table

Oracle Error Message

ORA-14187: partitioning method for LOCAL index is inconsistent with that of the underlying table

Reason for the Error

User attempted to create a LOCAL partitioned index that is not equi-partitioned with the underlying table. The partitioning types are mismatched.

Solution

Correct the CREATE INDEX statement to ensure that the index partitionining method is consistent with that of the base table