foreign key between different users.
From: george hart <gehart24_at_yahoo.com>
Date: 19 Apr 2002 19:23:19 -0700
Message-ID: <c490a7ae.0204191823.3427f7a5_at_posting.google.com>
Date: 19 Apr 2002 19:23:19 -0700
Message-ID: <c490a7ae.0204191823.3427f7a5_at_posting.google.com>
Hello,
Does anyone know if it is possible to have a foreign key for a column
between two different users in oracle 9i?
basically i am doing something like this:
create table foo(id int references otheruser.sometable(id));
and getting a
Any thoughts?
Thank you,
George
Received on Sat Apr 20 2002 - 04:23:19 CEST
ORA-00942: table or view does not exist