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.

参与评论 您还未登录,请先 登录 后发表或查看评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
©️2022 CSDN 皮肤主题:数字20 设计师:CSDN官方博客 返回首页
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值