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.