ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table

Solution ID:ORA-14095

Type: Oracle

Cause

The table in the EXCHANGE operation is either clustered or partitioned

Actions

LONG data types are not supported with partitioned tables. Create table without LONG column or change table to not partitioned. If adding column, do not use LONG datatype. If modifying attributes of a column to change data type to LONG, it has to be a non partitioned 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/9248767


https://community.oracle.com/message/3410311


https://community.oracle.com/message/10808301


Browse all solutions to database errors from Oracle, MS SQL, or MySQL