Cause
An attempt was made to issue an ALTER TABLE EXCHANGE PARTITION | SUBPARTITION command, but the non-partitioned table cannot be used in the EXCHANGE because one or more of the following apply:
An attempt was made to issue an ALTER TABLE EXCHANGE PARTITION | SUBPARTITION command, but the non-partitioned table cannot be used in the EXCHANGE because one or more of the following apply:
Disable currently enabled matching UNIQUE constraints on both tables or ensure that INCLUDING INDEXES option is used.
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm
https://community.oracle.com/message/11244010
https://community.oracle.com/message/2024588
Browse all solutions to database errors from Oracle, MS SQL, or MySQL