Oracle Error ORA-39270: Cannot alter a LOB column to another data type.

Oracle Error Message

ORA-39270: Cannot alter a LOB column to another data type.

Reason for the Error

DBMS_METADATA_DIFF was comparing two table columns, the first of type CLOB, NCLOB or BLOB, the second of some other data type. There is no SQL ALTER statement to change the data type of a LOB column.

Solution

The difference cannot be eliminated with an SQL ALTER statement.