The current version of Toad requires users to have CREATE/INSERT/SELECT privileges to global temporary tables. So Toad can create and insert rows in QUEST_OPTI.QUEST_TEMP_EXPLAIN temp table. Because of the restricted read-only database, user would like to create the temporary table in a central schema, grant access to that temporary table to PUBLIC and create a public synonym leading to the temporary table. He would Toad to use the synonyms to run the Explain Plan.
This scenario is possible in Toad for Oracle, as it locates and uses the plan table synonym, however, TDA does not have this verification and hence it errors out to ORA-01031 error when using the Explain Plan, since it tries to create the plan table.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center