I'm using Quest SQL Optimizer for Oracle 7.4.1. Whenever I try to run the "Tuning Lab" portion of the tool, it tells me that I need to create a QUEST_SL_TEMP_EXPLAIN1
table. When I tell it to execute that CREATE TABLE command, it comes back with the error: ORA-01039: insufficient privileges on underlying objects of the view.
Try adding the CONNECT role, SELECT_CATALOG_ROLE role, and the SELECT ANY DICTIONARY privilege to your User (ensure you grant the roles as GRANTED and as DEFAULT as well), then restart SQL Optimizer, and then see if that will resolve the error.
Run the script below in a SQL Editor i.e. SQL Plus or Toad for Oracle (ensure you use a DBA user to run it):
After creating the global temporary table QUEST_SL_TEMP_EXPLAIN1 and Granting it to PUBLIC, and it still does not work, please go to SQL Optimizer’s Options | General | choose the option “Use the following plan table” | put in the Schema Name where you created the QUEST_SL_TEMP_EXPLAIN1 table under “(Schema)” | and then put QUEST_SL_TEMP_EXPLAIN1 under “(Table name)”.