sql - Can I create Foreign Keys across Databases?

Question

We have 2 databases - DB1 & DB2.

Can I create a table in DB1 that has a relation with one of the tables in DB2? In other words, can I have a Foreign Key in my table from another database?

I connect to these databases with different users. Any ideas?

Right now, I receive the error:

ORA-00942:Table or view does not exist

Answer 1

No, Oracle does not allow you to create a foreign key constraint that references a table via a database link. You would have to use triggers to enforce the integrity.