如何在oracle中的不同模式中创建外键 [英] How to create foreign key in different schema in oracle

问题描述

如何在oracle中创建不同模式中的外键

How to create foreign key in different schema in oracle

推荐答案

首先需要修复授权，显然使用有权这样做的用户：

First you need to fix the grants, obviously using a user with rights to do so:

GRANT REFERENCES ON TheOtherSchema.TheOtherTable TO MySchemaUser

然后你在桌子上添加约束

Then you add the constraint on your table

ALTER TABLE MyTable
  ADD CONSTRAINT MyTable_ForeignTableID_fk FOREIGN KEY (
    ForeignTableID
  ) REFERENCES TheOtherSchema.TheOtherTable(
    ForeignTableID
  )
/

两个用户



First用户EBMSPTS第二个用户TESTNEW ...



表名为TRAINING_MASTER



在TESTNEW.TRAINING_MASTER TO上授予参考资料TESTNEW;



***成功



ALTER TABLE TRAINING_MASTER

ADD CONSTRAINT MyTable_ForeignTableID_fk FOREIGN KEY（

REG_ID

）参考文献TESTNEW.TRAINING_MASTER（

REG_ID

）

/



***ORA-00942错误：表或​​视图不存在

TWO USERS

First User EBMSPTS second user TESTNEW...

TABLE NAME TRAINING_MASTER

GRANT REFERENCES ON TESTNEW.TRAINING_MASTER TO TESTNEW;

*** success

ALTER TABLE TRAINING_MASTER
ADD CONSTRAINT MyTable_ForeignTableID_fk FOREIGN KEY (
REG_ID
) REFERENCES TESTNEW.TRAINING_MASTER(
REG_ID
)
/

*** Error for " ORA-00942: table or view does not exist "

这篇关于如何在oracle中的不同模式中创建外键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！