Cause
You attempted to use either a nonconstant interval or an interval whose data type does not correspond to the partitioning column
You attempted to use either a nonconstant interval or an interval whose data type does not correspond to the partitioning column
Ensure that the indexes for the two tables have indexes which follow this rule: For every nonpartitioned index for the nonpartitioned table, there has to be an identical LOCAL index on the partitioned table and vice versa. To be identical, the column position type and size have to be the same.
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm
https://community.oracle.com/message/3372272
https://community.oracle.com/message/9570696
https://community.oracle.com/message/10380327
Browse all solutions to database errors from Oracle, MS SQL, or MySQL