Oracle Solution for Error ora-14187

Solution for Oracle Error ORA-14187

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

What triggered the Error:

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

What should we do to fix it:

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