Foreign Key question

From: Sean <dolans_at_my-deja.com>
Date: Thu, 12 Oct 2000 15:32:44 GMT
Message-ID: <8s4lis$irb$1@nnrp1.deja.com>

I would like to create a FK between two tables that belong to different owners: [This resides on an Oracle 8i, one instance, 2 schemas foo and bar)

TableA (owner and schema foo)

---

foo_id (PK)
username (FK)
comments

TableB (owner and schema bar)

---

username (PK)
firstName

So if I do a :
ALTER TABLE "FOO"."TABLEA" ADD( FOREIGN KEY (USERNAME) REFERENCES "BAR"."TABLEB"(USERNAME)); I get a ORA-00942 : table or view does not exist.

Is this possible to reference a Foreign Key from another owner?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 12 2000 - 10:32:44 CDT