ORA-02440: Create as select with referential constraints not allowed

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.