mysql的外键可以跨库吗,我可以跨数据库创建外键吗？

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

解决方案

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.