Re: Foreign Key question

Get rid off double quotes in the sql statement and it should be OK.

Hope this helps.

Guang

In article <8s4lis$irb$1_at_nnrp1.deja.com>,   Sean <dolans_at_my-deja.com> wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 12 2000 - 11:17:46 CDT