ORA-02446: CREATE TABLE ... AS SELECT failed - check constraint violated

ORA-02446: CREATE TABLE ... AS SELECT failed - check constraint violated
Cause: An attempt was made to use a CREATE TABLE ... AS SELECT statement when some rows violated one or more CHECK constraints.
Action: Do not select rows that violate constraints.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:37

ORA-02446：CREATE TABLE ... AS SELECT失败 - 违反检查约束,
.原因：尝试在某些行违反一个或多个CHECK约束时使用CREATE TABLE ... AS SELECT语句。,
.操作：不要选择违反约束的行。,
.

aiaiDBA

13718043309

010-86462881

ORA-02446: CREATE TABLE ... AS SELECT failed - check constraint violated

1 个回答

相似问题