Cause
User attempted to create a LOCAL partitioned index with a number of sub-partitions which is different from that of the underlying table.
User attempted to create a LOCAL partitioned index with a number of sub-partitions which is different from that of the underlying table.
a) Specify a tablespace list in place of DEFAULT, or b) Remove STORE IN clause and specify tablespaces individually for each 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/3355340
Browse all solutions to database errors from Oracle, MS SQL, or MySQL