# Toad for Oracle - "Used by Tab" is not pulling dependency from other schemas **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [May 21, 2015, 2:30pm UTC](https://forums.toadworld.com/t/toad-for-oracle-used-by-tab-is-not-pulling-dependency-from-other-schemas/33350 "2015-05-21T14:30:19Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![sks2141](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@sks2141](https://forums.toadworld.com/u/sks2141)\ **Post date:** [May 21, 2015, 2:30pm UTC](https://forums.toadworld.com/t/toad-for-oracle-used-by-tab-is-not-pulling-dependency-from-other-schemas/33350/1 "2015-05-21T14:30:19Z")
When I select a table and then head to Used By Tab, I do not see dependencies from other schemas. I have noticed this behavior only on my machine, other developer machines show the entire dependency hierarchy, across different schemas. I have 1. Reset all the filters 2. Cleared the Schema browser filters 3. Cleared the history 4. Cleared the Table/View/MView Data Filters 5. Refreshed the Right side pane (which contains the Used By tab) 6. Restored to the default options, while configuring the RHS 7. Compiled the dependencies on that table 8. Restarted toad / my machine several times hoping to fix the issue But in vain. Has anyone every faced this issue and found a solution ? I am using Toad for Oracle Base Version 11.5.1.2. I am hoping to find the text file on my machine (if any), where the Used By Tab gets its query from. Is there a way to override the Query that this tab uses and use a more updated query ? Thanks. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [June 1, 2015, 8:32am UTC](https://forums.toadworld.com/t/toad-for-oracle-used-by-tab-is-not-pulling-dependency-from-other-schemas/33350/2 "2015-06-01T08:32:43Z")
Sorry for not answering this one sooner. Would SYS happen to be the “other schemas”? If so, go to Options -\> Schema Browser -\> Right Hand Side -\> “Omit SYS objects from procedure dependencies list”. Looks like this option is a bit mis labeled, but it applies to all dependency listings in the Schema Browser. FYI, there is no file on your machine where Toad gets its queries from. They are all compiled into Toad.exe. However, to see the query that Toad is running, go to the main menu -\> Database -\> Spool SQL -\> Spool to Screen. ---
**Author:** ![sks2141](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@sks2141](https://forums.toadworld.com/u/sks2141)\ **Post date:** [June 1, 2015, 9:05am UTC](https://forums.toadworld.com/t/toad-for-oracle-used-by-tab-is-not-pulling-dependency-from-other-schemas/33350/3 "2015-06-01T09:05:42Z")
Thanks John for your response. - SYS is not the other schema. Its a custom schema. (I tried going via Main menu to, View \> Toad Options \> Schema Browser \> Right Hand Side; but it does not apply in this case) The issue is that let’s say you have two schemas : ABC and DEF; such that in DEF schema, the DEF.Views are using dbObjects from ABC schema. When I head to ABC schema and for that dbObject, in the Used By tab, I do not see dependencies for DEF related views. However, we see the ‘DEF’-related dependencies on other developer’s machines. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [June 1, 2015, 9:09am UTC](https://forums.toadworld.com/t/toad-for-oracle-used-by-tab-is-not-pulling-dependency-from-other-schemas/33350/4 "2015-06-01T09:09:11Z")
Do a spool SQL on your machine when the Used by tab is loaded. Repeat on your co-workers machine. Post them both here. We’ll get it figured out. ---
**Author:** ![sks2141](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@sks2141](https://forums.toadworld.com/u/sks2141)\ **Post date:** [June 1, 2015, 10:09am UTC](https://forums.toadworld.com/t/toad-for-oracle-used-by-tab-is-not-pulling-dependency-from-other-schemas/33350/5 "2015-06-01T10:09:01Z")
Thanks for the suggestion. We found out that on my machine, the queries are getting pulled from ALL\_\* objects ex. Select owner, object\_type, object\_name, object\_id, status from sys. **ALL\_OBJECTS** where object\_id in ( Select object\_id from public\_dependency connect by prior object\_id = referenced\_object\_id start with referenced\_object\_id = ( Select object\_id from sys. **ALL\_OBJECTS** where owner = :Owner and object\_name = :name and object\_type = :type )) :Owner(VARCHAR[9],IN/OUT)=‘ABC’ :name(VARCHAR[17],IN/OUT)=‘SampleTable’ :TYPE(VARCHAR[5],IN/OUT)=‘TABLE’ whereas, on other developer’s machines, the queries are getting pulled from 'DBA\_\* objects ex. Select owner, object\_type, object\_name, object\_id, status from sys. **DBA\_OBJECTS** where object\_id in ( Select object\_id from public\_dependency connect by prior object\_id = referenced\_object\_id start with referenced\_object\_id = ( Select object\_id from sys. **DBA\_OBJECTS** where owner = :Owner and object\_name = :name and object\_type = :type )) :Owner(VARCHAR[9],IN/OUT)=‘ABC’ :name(VARCHAR[17],IN/OUT)=‘SampleTable’ :TYPE(VARCHAR[5],IN/OUT)=‘TABLE’ ---
**Author:** ![sks2141](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@sks2141](https://forums.toadworld.com/u/sks2141)\ **Post date:** [June 1, 2015, 10:10am UTC](https://forums.toadworld.com/t/toad-for-oracle-used-by-tab-is-not-pulling-dependency-from-other-schemas/33350/6 "2015-06-01T10:10:21Z")
how to fix this issue - should I be reinstalling oracle **toad** on my end ? or is this like a configuration issue that is easy to fix ? ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [June 1, 2015, 10:11am UTC](https://forums.toadworld.com/t/toad-for-oracle-used-by-tab-is-not-pulling-dependency-from-other-schemas/33350/7 "2015-06-01T10:11:27Z")
Ah, yup, that could do it. Assuming that you are logging in as the same user, or that you at least both can select from the DBA\_ views, go to Options -\> Startup and check “Check for access to DBA views” ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [June 1, 2015, 10:12am UTC](https://forums.toadworld.com/t/toad-for-oracle-used-by-tab-is-not-pulling-dependency-from-other-schemas/33350/8 "2015-06-01T10:12:07Z")
Don’t reinstall Toad. Just check the option. ---
**Author:** ![sks2141](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@sks2141](https://forums.toadworld.com/u/sks2141)\ **Post date:** [June 1, 2015, 10:13am UTC](https://forums.toadworld.com/t/toad-for-oracle-used-by-tab-is-not-pulling-dependency-from-other-schemas/33350/9 "2015-06-01T10:13:27Z")
wow … that fixed it …thanks for the help ! You rock !