Return
-
Title
Executing alternatives gave ORA-00942: table or view does not exist -
Description
When executing the alternative using the Batch Run, SQL Optimizer gave the following error on all the alternatives:
ORA-06550: Line 21, column 56: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 21, column 4: PL/SQL: SQL Statement ignored
Why is SQL Optimizer complaining about tables not existing when I can run the query in Toad and sent it to SQL Optimizer from Toad?
-
Cause
SQL Optimizer has back end tables that it needs access to inorder to do a Batch Run.
-
Resolution
Running a “Batch Run” for the alternatives in SQL Optimizer requires access to the following SYS views.
SYS.V_$STATNAME
SYS.V_$MYSTAT
SYS.V_$SESSION
SYS.V_$SQL_PLAN
SYS.V_$SQLAREA
SYS.V_$SQL_PLAN_STATISTICS_ALL