I am using TOAD for Oracle version 220.127.116.11. Even though I have access to an Oracle View in another schema, I am unable to view or access it. For another Oracle View, I am unable to see any data, even though I can see the View - it just doesn’t return any data even when the data is there.
The interesting fact is that I am able to see the data for View VW_EMP_AUTOLOAD and access the view VW_EMP_DATA_BKP when I use Oracle SQL Developer. I also tried using another system, where TOAD version 12.6.053 is installed, and I able to see the view here as well.
Any reason for that? Do you think any session settings is causing this?