ORA-02440: Create as select with referential constraints not allowed
What triggered the Error:
create table foo (... ref. con. ...) as select ...;What should we do to fix it:
Create the table as select, then alter the table to add the constraints afterwards.