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.