All Oracle Error CodesOracle DBA Forum

ORA-02440:

Create as select with referential constraints not allowed
Cause: create table foo (... ref. con. ...) as select ...;
Action: Create the table as select, then alter the table to add the constraints afterwards.