Oracle 26ai

ORA-02440

Error Message

Create as select with referential constraints not allowed

create table foo (... ref. con. ...) as select ...;

Create the table as select, then alter the table to add the constraints afterwards.