Received: (qmail 4139 invoked from network); 3 Mar 2011 11:09:07 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 3 Mar 2011 11:09:02 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2B4ACDAAE35; Thu, 3 Mar 2011 12:09:00 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1299172140; bh=lMLQJR5IyD5d1OOVYvMrQR5Y+TfOdpz3XVmebwbo HDg=; h=MIME-Version:In-Reply-To:References:Date:Message-ID:Subject: From:To:Cc:Content-Type:Sender:Reply-To:List-help:List-unsubscribe: List-Id:List-subscribe:List-owner:List-post:List-archive; b=PQFq3a EWqnuIQwJkQHScJZGG8rZSE+GghGGXuWxiFUCCb1lH+eLml60hThtX3VGUsJU44Fh7A MY8fJVtgwH7No75teTpf/RNqfG/8cjc9rRQH29bObTRu5VU5NJ1Pz3yEkk0UNPDpoMG MjIhLUpZ82qpEWrDwLs6UHNNcRAQc+M= X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id c04fuJtx46vA; Thu, 3 Mar 2011 12:08:59 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7CB0DDAAE11; Thu, 3 Mar 2011 12:08:16 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 03 Mar 2011 12:07:35 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E4464DA750B for ; Thu, 3 Mar 2011 12:07:34 -0500 (EST) Authentication-Results: turing.freelists.org; dkim=pass (1024-bit key) header.i=@gmail.com Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 1idJH8Ar2vt4 for ; Thu, 3 Mar 2011 12:07:34 -0500 (EST) Received: from mail-qw0-f51.google.com (mail-qw0-f51.google.com [209.85.216.51]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 89672DA4C2F for ; Thu, 3 Mar 2011 12:07:34 -0500 (EST) Received: by qwb8 with SMTP id 8so962226qwb.10 for ; Thu, 03 Mar 2011 09:07:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=UA/1a1hUU1E1OdiNhjQMzp6qDB3RA+T5TfDQmrl33i4=; b=oWM32HBv6ByBcmHUFYCeKd9jL7uDdwljdh4G1ZtkkN9GsF6NzzEXru0LHYYgSaWzUP a/IzyFz8Aiq7GvijxN4F/i7WYUSPUziVB5EwpGcR+bXti5lajN1/P2bRA8KJKMdGoTK7 WX+LrNtvwVNC9Rs0uJaqFDeN3zNbAr26cUyUM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=glrc4upWTcl9tCBi92bG3cfAeGEDYLbA94974DAsW/p4xnyzfBmahlgLlN6uxXFnYM 5GZXLnB3NCJ3vubUY7Bgh5U+gsZ8mpSNRyoTijj07qRbYbbwYe0AwjNRXdfKolBo3pGt vhN8eE5N5py362EJnRGwRJ68wB6eFFlRRew+Y= MIME-Version: 1.0 Received: by 10.224.215.199 with SMTP id hf7mr1278631qab.375.1299172053806; Thu, 03 Mar 2011 09:07:33 -0800 (PST) Received: by 10.229.236.3 with HTTP; Thu, 3 Mar 2011 09:07:33 -0800 (PST) Received: by 10.229.236.3 with HTTP; Thu, 3 Mar 2011 09:07:33 -0800 (PST) In-Reply-To: <6AFC12B9BFCDEA45B7274C534738067F682890AA@AAPQMAILBX02V.proque.st> References: <4D6FBA51.9070405@sferacarta.com> <6AFC12B9BFCDEA45B7274C534738067F682890AA@AAPQMAILBX02V.proque.st> Date: Thu, 3 Mar 2011 17:07:33 +0000 Message-ID: Subject: Re: RE: references trace From: Niall Litchfield To: Mark.Bobak@proquest.com Cc: ORACLE-L , "jose.soares@sferacarta.com" Content-Type: multipart/alternative; boundary=20cf30051252c4eece049d97101a X-archive-position: 34814 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: niall.litchfield@gmail.com Precedence: normal Reply-To: niall.litchfield@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --20cf30051252c4eece049d97101a Content-Type: text/plain; charset=ISO-8859-1 Just adding to Mark, I wouldn't rely on the constraint name as your postgres eg seems to do. None of this deals with apps that 'enforce' relationships in the app. On 3 Mar 2011 16:05, "Bobak, Mark" wrote: You should take a look at DBA_CONSTRAINTS and DBA_CONS_COLUMNS. Look for constraints with CONSTRAINT_TYPE='R'. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.or... --20cf30051252c4eece049d97101a Content-Type: text/html; charset=ISO-8859-1

Just adding to Mark, I wouldn't rely on the constraint name as your postgres eg seems to do. None of this deals with apps that 'enforce' relationships in the app.

On 3 Mar 2011 16:05, "Bobak, Mark" <Mark.Bobak@proquest.com> wrote:

You should take a look at DBA_CONSTRAINTS and DBA_CONS_COLUMNS.

Look for constraints with CONSTRAINT_TYPE='R'.


-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.or...

--20cf30051252c4eece049d97101a-- -- http://www.freelists.org/webpage/oracle-l