Cause
A COALESCE PARTITION command was issued when there is only one partition in the table or index, which is illegal
A COALESCE PARTITION command was issued when there is only one partition in the table or index, which is illegal
Ensure that the two tables do not have FOREIGN KEY constraints defined on any column or disable all FOREIGN KEY constraints on both tables. Then retry the operation.
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm
Browse all solutions to database errors from Oracle, MS SQL, or MySQL