I am have toad 184.108.40.2068 running on 18c client. When I use schema browser to view views or mviews I get ora-00904 ref invalid identifier.
Any suggestions? The database i am viewing is 19c. That cannot be the issue because other people in the group can see the views. I am leaning towards my setting. Any help appreciated.
FYI I copied another users setting and it fixed it. I still do not know whet setting, but its working.
If it happens again, go to main menu: Database->Spool SQL->Spool to screen. That will capture the SQLs that Toad executes. Then you'll be able to see where the error comes from.