Oracle Database 12c New Features

ORA-14111: creation of a GLOBAL partitioned index on clustered tables is not supported

ORA-14111: creation of a GLOBAL partitioned index on clustered tables is not supported


Cause:


An attempt was made to create a GLOBAL partitioned index on a clustered table which is currently illegal.



Action:


Remove PARTITION BY RANGE/HASH clause along with any partition descriptions to create a GLOBAL non-partitioned index on a clustered table