Re: SQL to find the list of objects that reference a table

From: gazzag <gareth_at_jamms.org>
Date: Thu, 14 Aug 2008 03:37:38 -0700 (PDT)
Message-ID: <d49799c1-b5e6-49c8-a11c-fb21d612f732@b1g2000hsg.googlegroups.com>


On 14 Aug, 08:30, Saravanan <vsr.sarava..._at_gmail.com> wrote:
> Hi all
>     I want to find all the objects that reference a given table. Can
> anyone please provide the SQL query to do the same?
>
> Thanks
> Saravanan

Check out the DBA_DEPENDENCIES view.

HTH -g Received on Thu Aug 14 2008 - 05:37:38 CDT

Original text of this message