Return
-
Title
Invalid SQL ORA-00904 for any Select * from any table. -
Description
After upgrading to SQL Optimizer 9.x, when trying to optimize, the errors "The parser did not identify the text as a valid SQL statement" and/or "ORA-00904: Invalid Identifier" is given for any SQL statement. ORA-00905 can also occur. This error does not occur in previous versions of SQL Optimizer.
A prompt is given to create Plan Table. This seems to be created successfully but the error still occurs.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.