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

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


Cause:


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



Action:


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