ORA-01463: cannot modify column datatype with current constraint(s)

ORA-01463: cannot modify column datatype with current constraint(s)
Cause: An attempt was made to modify the datatype of column which has referential constraints; or has check constraints which only allows changing the datatype from CHAR to VARCHAR or vise versa.
Action: Remove the constraint(s) or do not perform the offending operation.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-01463：无法使用当前约束修改列数据类型,
.原因：试图修改具有引用约束的列的数据类型; 或者具有只允许将数据类型从CHAR更改为VARCHAR或反之亦然的检查约束。,
.操作：删除约束或不执行令人讨厌的操作。,
.

aiaiDBA

13718043309

010-86462881

ORA-01463: cannot modify column datatype with current constraint(s)

1 个回答

相似问题