Re: Experience with foreign keys across schemas?

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Tue, 23 Nov 2004 00:10:57 +0100
Message-ID: <osr4q0lbpe828rbdo05k00s6or73ukdk43@4ax.com>

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote:

>|
>| > Today, I was asked to setup a new schema with tables which will
>| > contain foreign key references to tables in another schema.
>|
>
>This is really very, very normal and totally supported by Oracle.

I know that it is technically sound to setup FK across schemas. What I meant was that it might not be a reasonable development style. Having many FK this way makes things harder to maintain, I expect.

But you convinced me that after all it is not that bad, and in some situations it provides a certain degree of separation of entities which would be otherwise all in one schema.

Thanks to all of you for your comments.

Rick Denoire Received on Mon Nov 22 2004 - 17:10:57 CST