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.