Oracle Database 12c New Features

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

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


Cause:


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



Action:


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