ORA-00904: & quot; OTHER_TAG & quot;: Invalid identifier Problem

ORA-00904: "OTHER_TAG": Invalid identifier problem SQL> set autotrace on SQL> SELECT SYSDATE FROM DUAL; www.2cto.com SYSDATE -------------- 26-9 month-12 execution plan failed ERROR: an uncaught error in function display has happened; please contact Oracle support www.2cto.com Please provide also a DMP file of the used plan table PLAN_TABLE ORA-00904: "OTHER_TAG": identifier invalid statistics ----- Defaults 0 recursive cballs 0 db block gets 0 consistent gets 0 physical reads 0 redo size 347 bytes sent via SQL * Net to client 338 bytes encoded ed via SQL * Net from client 2 SQL * Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed solution: Need to recreate or upgrade the plan table, it is still the 8i one. please drop the table and ru NSQL> drop table PLAN_TABLE; the table has been deleted. The SQL> @ C: \ oracle \ product \ 10.2.0 \ client_2 \ RDBMS \ ADMIN \ utlxplan. SQL www.2cto.com table has been created. SQL> set autotrace on SQL> SELECT SYSDATE FROM DUAL; SYSDATE -------------- 26-9 month-12 execution Plan -------------------------------------------------------- Plan hash value: 1388734953 bytes | Id | Operation | Name | Rows | Cost (% CPU) | Time | --------------------------------------------------------- | 0 | select statement | 1 | 2 (0) | 00:00:01 | 1 | fast dual | 1 | 2 (0) | 00:00:01 | metrics www.2cto.com statistics limit 0 recursive call0 db block gets 0 consistent gets 0 physical reads 0 redo size 347 bytes sent via SQL * Net to client 338 bytes encoded ed via SQL * Net from client 2 SQL * Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed SQL>