# where-used-list by TOAD

**URL:** <https://forums.toadworld.com/t/where-used-list-by-toad/10853>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [November 8, 2011, 9:51am UTC](https://forums.toadworld.com/t/where-used-list-by-toad/10853 "2011-11-08T09:51:29Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![cetzhbo](https://avatars.discourse-cdn.com/v4/letter/c/4491bb/32.png) [@cetzhbo](https://forums.toadworld.com/u/cetzhbo)\
**Post date:** [November 8, 2011, 9:51am UTC](https://forums.toadworld.com/t/where-used-list-by-toad/10853/1 "2011-11-08T09:51:29Z")

</div>

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,

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 8, 2011, 9:51am UTC](https://forums.toadworld.com/t/where-used-list-by-toad/10853/2 "2011-11-08T09:51:29Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![cetzhbo](https://avatars.discourse-cdn.com/v4/letter/c/4491bb/32.png) [@cetzhbo](https://forums.toadworld.com/u/cetzhbo)\
**Post date:** [November 8, 2011, 3:22pm UTC](https://forums.toadworld.com/t/where-used-list-by-toad/10853/3 "2011-11-08T15:22:53Z")

</div>

Appreciate very much

---

<div class="post-metadata">

**Author:** ![matt.wilkins](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/matt.wilkins/32/146_2.png) [@matt.wilkins](https://forums.toadworld.com/u/matt.wilkins)\
**Post date:** [November 9, 2011, 9:00am UTC](https://forums.toadworld.com/t/where-used-list-by-toad/10853/4 "2011-11-09T09:00:23Z")

</div>

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](https://global.discourse-cdn.com/quest/original/1X/e8288ef7bf69daaab6959f752b25ca292478b911.jpeg)

---

<div class="post-metadata">

**Author:** ![matt.wilkins](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/matt.wilkins/32/146_2.png) [@matt.wilkins](https://forums.toadworld.com/u/matt.wilkins)\
**Post date:** [November 9, 2011, 9:00am UTC](https://forums.toadworld.com/t/where-used-list-by-toad/10853/5 "2011-11-09T09:00:23Z")

</div>

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](https://global.discourse-cdn.com/quest/original/1X/278be512a68050c664416c8c1dd90a338bc191af.jpeg)

---

<div class="post-metadata">

**Author:** ![reedda](https://avatars.discourse-cdn.com/v4/letter/r/a9adbd/32.png) [@reedda](https://forums.toadworld.com/u/reedda)\
**Post date:** [November 9, 2011, 9:39am UTC](https://forums.toadworld.com/t/where-used-list-by-toad/10853/6 "2011-11-09T09:39:16Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![matt.wilkins](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/matt.wilkins/32/146_2.png) [@matt.wilkins](https://forums.toadworld.com/u/matt.wilkins)\
**Post date:** [November 9, 2011, 9:39am UTC](https://forums.toadworld.com/t/where-used-list-by-toad/10853/7 "2011-11-09T09:39:16Z")

</div>

That may indicate another problem entirely. Has your DBA gathered dictionary  
statistics lately?  
 ![image001.jpeg](https://global.discourse-cdn.com/quest/original/2X/1/105e8b67301036f67de4a386f2fc592d982dbad2.jpeg)

---

<div class="post-metadata">

**Author:** ![matt.wilkins](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/matt.wilkins/32/146_2.png) [@matt.wilkins](https://forums.toadworld.com/u/matt.wilkins)\
**Post date:** [November 9, 2011, 9:39am UTC](https://forums.toadworld.com/t/where-used-list-by-toad/10853/8 "2011-11-09T09:39:16Z")

</div>

That may indicate another problem entirely. Has your DBA gathered dictionary  
statistics lately?  
 ![image001.jpeg](https://global.discourse-cdn.com/quest/original/1X/278be512a68050c664416c8c1dd90a338bc191af.jpeg)

---

<div class="post-metadata">

**Author:** ![matt.wilkins](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/matt.wilkins/32/146_2.png) [@matt.wilkins](https://forums.toadworld.com/u/matt.wilkins)\
**Post date:** [November 9, 2011, 9:39am UTC](https://forums.toadworld.com/t/where-used-list-by-toad/10853/9 "2011-11-09T09:39:16Z")

</div>

That may indicate another problem entirely. Has your DBA gathered dictionary  
statistics lately?  
 ![image001.jpeg](https://global.discourse-cdn.com/quest/original/1X/e8288ef7bf69daaab6959f752b25ca292478b911.jpeg)
