From oracle-l-bounce@freelists.org Fri Jan 7 03:16:17 2005 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id j079GGV31680 for ; Fri, 7 Jan 2005 03:16:16 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id j079GGn31673 for ; Fri, 7 Jan 2005 03:16:16 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D302A72C686; Fri, 7 Jan 2005 04:22:50 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20603-95; Fri, 7 Jan 2005 04:22:50 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 329C972CA15; Fri, 7 Jan 2005 04:21:02 -0500 (EST) From: "Lex de Haan" To: , Subject: RE: Foreign Key Constraint ... Date: Fri, 7 Jan 2005 10:17:22 +0100 MIME-Version: 1.0 Content-type: text/plain X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcT0Qw4dpEfEzQy9QRqX9LOoJZbGIQAVi8Xw In-Reply-To: <41DDC2EC.4010505@alumni.sfu.ca> Message-Id: <20050107100544.8D20FDBBE@node42.naturaljoin.nl> Content-Transfer-Encoding: 8bit X-archive-position: 14456 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lex.de.haan@naturaljoin.nl Precedence: normal Reply-To: lex.de.haan@naturaljoin.nl X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi Lyndon, sorry for replying with a question, but this does not sound like a foreign key to me :-) what's the background of this constraint? what's the magic of this number 1000? maybe there is room for improvement in the underlying data model... cheers, Lex. ---------------------------------------------------------------- Tom Kyte Seminar: http://www.naturaljoin.nl/events/seminars.html ---------------------------------------------------------------- -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Lyndon Tiu Sent: Friday, January 07, 2005 00:00 To: oracle-l@freelists.org Subject: Foreign Key Constraint ... Hello, Can we have a foreign key column in tableB that points to a primary key in tableA, but the foreign key is only enforced if the foreign key value is greater than 1000? Thanks. -- Lyndon Tiu -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l