ORA-02440

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

Causa: Integrity constraints on a table cannot be created when creating the table using the CREATE TABLE... AS SELECT... form.

Acción: First, create the table, and then alter the table to add the desired integrity constraints.