When using the Auto Optimize tool on SQL code as non-schema owner, Toad will throws an "ORA-00942: table or view does not exist" error.
However using the SQL Tuning Adivser (OEM) in the same scenario will run without ORA errors. In addition, using the "DBMS_SQLTUNE" Oracle package to manually create a task, execute the task, then report the task in the same scenario will run as well; no need to qualify the schema name when not logged into the schema owner. Can Toad be adjusted so the Auto Optimize tool works the same way?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center