RE: Need your help!!!

From: Trassens Christian <trassenc_at_TELEFONICA.COM.AR>
Date: Tue, 27 Jun 2000 20:04:46 -0300
Message-Id: <10541.110600@fatcity.com>

Use the view dba_dependencies:

F.e.:

set verify off
accept schema char prompt 'Enter Schema: ' accept object_name char prompt 'Enter Objet: '

select  a.referenced_name "REFERENCIA",
        a.referenced_type "TIPO REF",
        b.status "ESTADO"

from dba_dependencies a, dba_objects b
where
a.referenced_name=b.object_name

and a.referenced_type= b.object_type
and a.name = upper('&object_name')
and a.owner = upper('&schema')

order by a.referenced_type
/

        Also you can use the deptree or ideptree views. To use it first you need to execute the dictionary script $ORACLE_HOME/rdbms/admin/utldtree.sql. And then follow the guidelines that have inside.

        Regards.

> -----Mensaje original-----
> De: Ngo, Tan [SMTP:TNGO_at_EFTIA.com]
> Enviado el: Martes 27 de Junio de 2000 18:40
> Para: Multiple recipients of list ORACLE-L
> Asunto: Need your help!!!
>
> Question: Is there a table/view that I can query to find out the
> reference
> tables from a view?
> What I meant here is: I have a view which comprises more than one table.
> I
> need a way to find out which table(s) this view is buildt upon. If you
> have
> script to do this, I appreciate very much. Could you help ASAP
>
> Tan Ngo
> Database Specialist
> Direct Line (613)368-4151
> Cell. (613)286-0033
> e-mail: tngo_at_eftia.com <mailto:tngo_at_eftia.com> <<Archivo: Tech
Received on Tue Jun 27 2000 - 18:04:46 CDT