Cause
A foreign key constraint was specified with the referenced table belonging to a different table family.
Action
Specify foreign key reference on a table in the same table family.
Oracle 26ai
ORA-03839
Error Message
foreign key constraint must be on a table in the same table family