| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: FOREIGN KEY to a remote table. Is it possible?
Nope, if you want to enforce RI thru a link, you'll need to implement it via triggers, email me offline, i'll give you the concept, i had to do it about 5 years ago.
Joe
>From: "Andor Gyula" <gy.andor_at_euromacc.hu>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: FOREIGN KEY to a remote table. Is it possible?
>Date: Tue, 03 Apr 2001 05:40:45 -0800
>MIME-Version: 1.0
>Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net
>(8.9.3/8.8.7) with ESMTP id JAA13960for <jtestamail_at_localhost>; Tue, 3 Apr
>2001 09:33:47 -0400
>Received: from mail.the-testas.netby localhost with POP3
>(fetchmail-5.3.1)for jtestamail_at_localhost (multi-drop); Tue, 03 Apr 2001
>09:33:47 -0400 (EDT)
>Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by
>mail.acfi.net (8.11.0/8.11.0) with ESMTP id f33Ed3527925for
><oracle-l_at_the-testas.net>; Tue, 3 Apr 2001 09:39:03 -0500
>Received: from fatcity.UUCP (uucp_at_localhost)by newsfeed.cts.com
>(8.9.3/8.9.3) with UUCP id GAA25699;Tue, 3 Apr 2001 06:30:56 -0700 (PDT)
>Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002DF715;
>Tue, 03 Apr 2001 05:40:45 -0800
>Return-Path: <root_at_fatcity.cts.com>
>Message-ID: <F001.002DF715.20010403054045_at_fatcity.com>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: "Andor Gyula" <gy.andor_at_euromacc.hu>
>Sender: root_at_fatcity.com
>Errors-To: ML-ERRORS_at_fatcity.com
>Organization: Fat City Network Services, San Diego, California
>X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman
>Precedence: bulk
>X-Fetchmail-Warning: recipient address ORACLE-L_at_fatcity.com didn't match
>any local name
>X-SpamBouncer: 1.2 (10/20/00)
>X-SBPass: NoBounce
>X-SBClass: OK
>Status:
>
>HI,
>
>Is is possible to create a FOREIGN KEY constraint that references to a
>remote table through DATABASE LINK?
>
>Thanks in advance
>Gyula
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Andor Gyula
> INET: gy.andor_at_euromacc.hu
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa INET: teci_dba1_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Apr 03 2001 - 09:01:46 CDT
 |
 |