foreign key constraints across schemas
430619Oct 5 2004 — edited Oct 5 2004Below, i have devr1 and devg on the same instance, and i've granted dba to both users.
I heard it was possible to create a foreign key constraint across schema users. However, below, unless i'm doing it wrong, it doesnt seem possible.
Can anyone help?
Thanks.
SQL> alter table DEVR1.TBLACE
2 add constraint "FK_AceRole" foreign key (ROLEGUID)
3 references DEVG.TBLROLE (GUID);
references DEVG.TBLROLE (GUID)
*
ERROR at line 3:
ORA-00942: table or view does not exist
SQL> describe devg.tblrole;
Name Null? Type
----------------------------------------- -------- ----------------------------
GUID NOT NULL VARCHAR2(75)
MEMBERGUID VARCHAR2(75)
NAME NOT NULL VARCHAR2(75)
DESCRIPTION VARCHAR2(75)
ROLETYPE NOT NULL VARCHAR2(20)