Constructing Circularly Referenced Tables
You must add the foreign key constraints after the tables have been created, using: alter table table_name add constraint constraint_name &lt;constraint clause&gt;;

There is no other way.

Note that, due to your table design, you may have to create the constraints with the  initially deferred deferrable clause. This forces Oracle to defer constraint checking until commit time &amp; may be necessary if you cannot use an INSERT ALL statement and need to insert dependant rows into the two tables with separate statements.