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