Good Morning Tony and John,
It does not get much simpler that then tuning SELECT 1 FROM DUAL: TOAD had no issue with tuning SELECT 1 FROM DUAL in each of the three schema in the problem
SQL (WIARPT, EGRANTS and INDIAN). I have done SQL tuning in the past, so I assumed the error was talking about my views, a more specific error report would be nice. On double check I have one more view to replace with its source SQL to eliminate all views.
I recall having gone through the steps to replace it, but it is still in the select, saying I did not complete the job.
The question I have is, are select rights on a source tables sufficient for SQL tuning, all the source tables for the view are in a different schema, EGRANTS,
than where the SQL is being run, WIARPT.
All three schema have select access to the SYS views you mentioned: