Return
-
Title
"ERROR: "Unable to parse SQL, error ORA-00904: "INCARN_KFFXP": invalid identifier" -
Description
Having an issue with one of the SQL queries being run to get ASM information. The query is parsed and executed correctly in the latest version of Toad for Oracle 12.1 as well as SQLPlus with an 11.2.0.3 Oracle client. However using the Auto-Optimizer and Advanced SQL Optimization from Toad produces the following Oracle error when parsed: ORA-00904: "INCARN_KFFXP": invalid identifier.
Is there a difference in the Toad and SQL Optimizer parsers? To test this run the attached script as sysdba as you'll need access to x$ tables.
-
Cause
The fixed tables in Oracle are not recognized in the parser so SQL using the x$kffxp will return error when optimized.
-
Resolution
WORKAROUND
None.
STATUS
Waiting for a fix in a future release of SQL Optimizer for Oracle.
-
Defect ID
ST 114392