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.