| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to get the list of tables used in a view?
Rachel,
Thanks,
Ashoke
>From: "Rachel Carmichael" <carmichr_at_hotmail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: How to get the list of tables used in a view?
>Date: Fri, 13 Jul 2001 02:40:49 -0800
>
>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 <teci_at_the-testas.net>
>>Reply-To: ORACLE-L_at_fatcity.com
>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>>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: teci_at_the-testas.net
>>
>>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
>>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: carmichr_at_hotmail.com
>
>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
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHOKE MANDAL INET: ashoke_mandal_at_hotmail.com 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 also send the HELP command for other information (like subscribing).Received on Fri Jul 13 2001 - 09:19:49 CDT
 |
 |