Environment Details:
OS: Linux 5.8
Database Version: 11.2.0.3.0
Issue: ERROR: an uncaught error in function display has happened; please contact Oracle support
Please provide also a DMP file of the used plan table PLAN_TABLE
OS: Linux 5.8
Database Version: 11.2.0.3.0
Issue: ERROR: an uncaught error in function display has happened; please contact Oracle support
Please provide also a DMP file of the used plan table PLAN_TABLE
ORA-00904: "OTHER_TAG": invalid identifier
When we generate the explain plan and try to get the explain plan details from plan_table we get the above mentioned error.
The reason may be the plan table has been corrupted. We need to recreate the plan table using the script utlxplan.sql from $ORACLE_HOME/rdbms/admin and it will work fine.
When we generate the explain plan and try to get the explain plan details from plan_table we get the above mentioned error.
The reason may be the plan table has been corrupted. We need to recreate the plan table using the script utlxplan.sql from $ORACLE_HOME/rdbms/admin and it will work fine.
No comments:
Post a Comment