Oracle Error ORA-14186: number of sub-partitions of LOCAL index must equal that of the underlying table

Oracle Error Message

ORA-14186: number of sub-partitions of LOCAL index must equal that of the underlying table

Reason for the Error

User attempted to create a LOCAL partitioned index with a number of sub-partitions which is different from that of the underlying table.

Solution

Correct the CREATE INDEX statement to specify a correct number of sub-partitions