the view will show as dependent on a bunch of tables so you could query
dba_dependencies looking for the view as the dependent object
>From: Joe Testa <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: How to get the list of tables used in a view?
>Date: Thu, 12 Jul 2001 20:10:28 -0800
>
>ok its late but off the top of my head, dba_dependencies?
>
>this is only a guess, as I'm heading off to bed and didnt verify it at
>all :)
>
>joe
>ASHOKE MANDAL wrote:
> >
> > Greetings,
> >
> > Is there any dictionary table/view where I can query the name of all the
> > tables used by a particular view?
> >
> > The way I do now is : Query the line containing 'from' in text field of
> > dba_views for the specified view.
> >
> > Is there any other way to get the list of the tables used by a view?
> >
> > Thanks,
> > Ashoke
> >
> > _________________________________________________________________
> >
>--
>Joe Testa
>Performing Remote DBA Services, need some backup DBA support?
>For Sale: Oracle-dba.com domain, its not going cheap but feel free to
>ask :)
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Joe Testa
> INET: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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
>also send the HELP command for other information (like subscribing).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).
