RE: Re: RE: where-used-list by TOAD

That may indicate another problem entirely. Has your DBA gathered dictionary statistics lately?

From: [email protected] [mailto:[email protected]] On Behalf Of David Reed
Sent: Wednesday, November 09, 2011 10:39 AM
To: [email protected]
Subject: [toad] Re: RE: where-used-list by TOAD



Message from: reedda


Yes, but you may have to wait a longggggg time for that to return. At least in my environment.

_______________________________________

Historical Messages


Author: David Reed
Date: Wed Nov 09 07:39:16 PST 2011
Yes, but you may have to wait a longggggg time for that to return. At least in my environment.
__

Author: matt.wilkins
Date: Wed Nov 09 07:00:23 PST 2011
Phyllis has good advice, but if you're looking for other objects (functions, procedures, etc.) in the DB that use a specific view, then go to the Views tab in Schema Browser, then select the Deps tab on the right.
__

Author: andy zhang
Date: Tue Nov 08 13:22:53 PST 2011

Appreciate very much[Image removed by sender.]

__

Author: Phyllis Helton
Date: Tue Nov 08 07:51:29 PST 2011
It sounds like you want the Object Search utility. Under the "Search" menu is the option for "Object Search". You can enter in your view name and what kinds of objects you want to have TOAD search for it and then let it do its magic.
__

Author: andy zhang
Date: Tue Nov 08 07:51:29 PST 2011
Hello expert,

       I have a view in the DB, I want to check where this view is used in the DB by TOAD, please tell me how to do this search where-used-list?

Many Thanks,
__
_______________________________________