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

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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:52

ORA-39269：无法将类型为LONG的列更改为除LOB之外的任何列。,
.原因： DBMS_METADATA_DIFF正在比较两个表列，第一个类型为LONG，第二个为LOB以外的数据类型。没有SQL ALTER语句将长数据类型修改为除CLOB或NCLOB之外的任何数据类型。,
.操作：使用SQL ALTER语句无法消除该差异。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题