select * from table(dbms_xplan.display);该如何解决
select * from table(dbms_xplan.display);
select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
--------------------------------------------
ERROR: cannot get definition for table 'PLAN_TABLE'
ORA-00980: synonym translation is no longer valid
怎么解决?
------解决方案--------------------
SQL> select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
---------------------------------------------
Plan hash value: 1357081020
--------------------------------------
------解决方案--------------------
Id
------解决方案--------------------
Operation
------解决方案--------------------
Name
------解决方案--------------------
Rows
------解决方案--------------------
Bytes
------解决方案--------------------
Cost (%CPU)
------解决方案--------------------
Time
------解决方案--------------------
--------------------------------------
------解决方案--------------------
0
------解决方案--------------------
SELECT STATEMENT
------解决方案--------------------
------解决方案--------------------
7
------解决方案--------------------
select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
--------------------------------------------
ERROR: cannot get definition for table 'PLAN_TABLE'
ORA-00980: synonym translation is no longer valid
怎么解决?
------解决方案--------------------
SQL> select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
---------------------------------------------
Plan hash value: 1357081020
--------------------------------------
------解决方案--------------------
Id
------解决方案--------------------
Operation
------解决方案--------------------
Name
------解决方案--------------------
Rows
------解决方案--------------------
Bytes
------解决方案--------------------
Cost (%CPU)
------解决方案--------------------
Time
------解决方案--------------------
--------------------------------------
------解决方案--------------------
0
------解决方案--------------------
SELECT STATEMENT
------解决方案--------------------
------解决方案--------------------
7
------解决方案--------------------