Sunday, April 6, 2014

Oracle Error with Explain Plan | ORA-00904: "OTHER_TAG": invalid identifier

when we try to explan plan, we get the below error, this is becauae the plan table is corrupted
drop and recreate the plan table.


SQL> explain plan for   select * from id_meta_ticket_query;
Explained.


SQL> SELECT * FROM TABLE(dbms_xplan.display);

PLAN_TABLE_OUTPUT
------------------------------------------------------
ERROR: an uncaught error in function display has happe  Please provide also a DMP file of the used plan
       ORA-00904: "OTHER_TAG": invalid identifier


SQL> drop table  plan_table;
Table dropped.

SQL> @$ORACLE_HOME/rdbms/admin/utlxplan.sql
Table created.

SQL> explain plan for  select * from id_meta_ticket_query;
Explained.

SQL>  select * from table(dbms_xplan.display());

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------
Plan hash value: 683485703

------------------------------------------------------------------------------------------
| Id  | Operation         | Name                 | Rows  | Bytes | Cost (%CPU)| Time     |
------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |                      |     1 |   867 |     2   (0)| 00:00:01 |
|   1 |  TABLE ACCESS FULL| ID_META_TICKET_QUERY |     1 |   867 |     2   (0)| 00:00:01 |
------------------------------------------------------------------------------------------

8 rows selected.

2 comments:

  1. Good Post
    Apponix Technologies
    https://www.apponix.com

    ReplyDelete
  2. This information is helpful. Thanks for sharing it

    ReplyDelete