Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Experience with foreign keys across schemas?

Re: Experience with foreign keys across schemas?

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 02 Dec 2004 21:23:29 GMT
Message-ID: <41af87ba.1216435231@localhost>


If you exp both schemas, this won't be a problem. "Enabling constraints" is the last step of exp

On Tue, 23 Nov 2004 00:10:57 +0100, Rick Denoire <100.17706_at_germanynet.de> wrote:

>DA Morgan <damorgan_at_x.washington.edu> wrote:
>
>>> Today, I was asked to setup a new schema with tables which will
>>> contain foreign key references to tables in another schema.
>>>
>>
>>I fail to see what's wrong with it?
>
>Well, I expect errors at imp/exp time, at least. These should not be a
>severe problem, I think, but just undesirable.
>
>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:23:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US