Cross user FK relationships
From: Nathan Stiltner <nks_at_stanleyassoc.com>
Date: 1996/12/06
Message-ID: <32A8C88F.10B7_at_stanleyassoc.com>#1/1
Date: 1996/12/06
Message-ID: <32A8C88F.10B7_at_stanleyassoc.com>#1/1
Hi,
We are trying to establish a relationship between tables belonging to
two owners in an Oracle 7.1.3 database. No matter what rights the user
who tries to run the alter script has (i.e. dba, etc.) the database
comes back with an error saying that it cannot find the table even
though we fully qualified it (i.e. owner.tablename). Does anyone know
if this is supported in Oracle?
Thanks in advance for your help!
Nathan Stiltner