Re: Experience with foreign keys across schemas?

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 02 Dec 2004 21:22:46 GMT
Message-ID: <41af8789.1216386401@localhost>

If it's a feature that's been in oracle for ages, then it's working... I don't see any problems with it, and we've been doing it for years.

On Thu, 18 Nov 2004 21:43:06 +0100, Rick Denoire <100.17706_at_germanynet.de> wrote:

>Hello
>
>Today, I was asked to setup a new schema with tables which will
>contain foreign key references to tables in another schema.
>
>I don't like that. I am sure that's wrong, but am missing arguments.
>OK, things like "delete from table <tralala> cascade" or "drop user
><john> cascade" tend to be dangerous. What else?
>
>Thanks
>Rick Denoire

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Thu Dec 02 2004 - 15:22:46 CST