Toad World® Forums

where-used-list by TOAD

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,

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.

Appreciate very much

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.
image001.jpeg

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.
image001.jpeg

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

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

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

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