Oracle Error ORA-02446: CREATE TABLE … AS SELECT failed – check constraint violated

Oracle Error Message

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

Reason for the Error

An attempt was made to use a CREATE TABLE … AS SELECT statement when some rows violated one or more CHECK constraints.

Solution

Do not select rows that violate constraints.