ORA-39269: Cannot alter a column of type LONG to anything other than LOB. ORACLE 报错 故障修复 远程处理

文档解释

ORA-39269: Cannot alter a column of type LONG to anything other than LOB.

Cause: DBMS_METADATA_DIFF was comparing two table columns, the first of type LONG, the second of a data type other than LOB. There is no SQL ALTER statement to modify a long data type to anything other than a CLOB or NCLOB.

Action: The difference cannot be eliminated with an SQL ALTER statement.

ORA-39269错误表明,无法将LONG类型的列更改为LOB类型以外的类型。

官方解释

常见案例

一般处理方法及步骤


数据运维技术 » ORA-39269: Cannot alter a column of type LONG to anything other than LOB. ORACLE 报错 故障修复 远程处理