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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/