Cause
User attempted to create a UNIQUE partitioned index whose sub-partitioning columns do not form a subset of its key columns which is illegal
User attempted to create a UNIQUE partitioned index whose sub-partitioning columns do not form a subset of its key columns which is illegal
remove invalid option(s) from the list of physical attributes of an index partition
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm
https://community.oracle.com/message/4485805
https://community.oracle.com/message/1477274
Browse all solutions to database errors from Oracle, MS SQL, or MySQL