Re: Creating foreign keys across different tablespace

From: <sybrandb_at_yahoo.com>
Date: 5 Mar 2004 06:02:12 -0800
Message-ID: <a1d154f4.0403050602.666a67a1@posting.google.com>

ahk_at_writeme.com (ahk) wrote in message news:<eb02dbae.0403042356.70ae910d_at_posting.google.com>...
> Hi,
>
> As above.
> The error I got is "ORA-00942: table or view does not exist". Any ideas?
> TIA.
Either you need to qualify the table_name with the owner, or the owner didn't grant you reference privilege on the affected table. BTW: There is no relation between foreign keys and tablespaces. There is a relation between foreign key and schemas.

Sybrand Bakker
Senior Oracle DBA Received on Fri Mar 05 2004 - 08:02:12 CST