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

Oracle Error Message

ORA-14024: number of 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 partitions which is different from that of the underlying table.

Solution

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