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.