RE: Need your help!!!

From: William Beilstein <BeilstWH_at_obg.com>
Date: Wed, 28 Jun 2000 10:50:26 -0400
Message-Id: <10542.110664@fatcity.com>

If you just want to see the select that makes up the view, do the = following. For purpose of the example, the view name will be TEST_VIEW and = the schema would be TEST

set arraysize 1
set long 32767
select text from dba_views
where owner =3D 'TEST'
and view_name =3D 'TEST_VIEW';

This view is only available to the dba. If you can get into the TEST = schema, you can use

set arraysize 1
set long 32767
select text from user_views
and view_name =3D 'TEST_VIEW';

>>> Trassens Christian <trassenc_at_TELEFONICA.COM.AR> 06/27/00 08:14PM >>> 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=3Db.object_name

and a.referenced_type=3D b.object_type
and a.name =3D upper('&object_name')
and a.owner =3D 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]=20
> Enviado el: Martes 27 de Junio de 2000 18:40
> Para: Multiple recipients of list ORACLE-L
> Asunto: Need your help!!!

>=20

> 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
> =20
> 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
> Tools.gif>>=20

--=20
Author: Trassens Christian
  INET: trassenc_at_TELEFONICA.COM.AR=20

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 Received on Wed Jun 28 2000 - 09:50:26 CDT