Cause
You attempted to use interval partitioning on a table partitioned on a column of data type other than number or date/time.
You attempted to use interval partitioning on a table partitioned on a column of data type other than number or date/time.
Perform EXCHANGE [SUB]PARTITION without the CASCADE option or ensure that exactly one table matches the specified table.
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm
https://community.oracle.com/message/9515330
https://community.oracle.com/message/10789455
https://community.oracle.com/message/10824303
https://community.oracle.com/message/10975945
Browse all solutions to database errors from Oracle, MS SQL, or MySQL