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.
RESOLUTION 1:
Verify that the schema's access to 'DBMS_LOB' and 'DBMS_XPLAN' objects and privileges.
RESOLUTION 2:
Specify a plan table in options (Options | General) and that the schema has access to.
