How to Auto Optimize SQL as non-schema owner and without qualifying schema name in SQL code? (4227107)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How to Auto Optimize SQL as non-schema owner and without qualifying schema name in SQL code?
Description

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?
Cause

Feature does not exist currently in Toad.
Resolution

WORKAROUND:
None.
STATUS:
An enhancement request is required to vote for new changes to be included in Toad for Oracle. Click here to go to the Toad Idea Pond to create or vote for this idea.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title