underlying table of a LOCAL partitioned index must be partitioned

Solution ID:ORA-14016

Type: Oracle

Cause

User attempted to create a LOCAL partitioned index on a non-partitioned table which is illegal. Only GLOBAL indices (partitioned or otherwise) may be created on a non-partitioned table.

Actions

rename partition(s) to ensure that their names are unique among partitions of the table or index being created

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


https://community.oracle.com/message/3229900


Browse all solutions to database errors from Oracle, MS SQL, or MySQL