Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Experience with foreign keys across schemas?
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