after upgrade to 11.2.0.2 PERFSTAT.STATSPACK ORA-00980: synonym translation is no longer valid
After I upgraded my 10.2.0.3 on Linux to 12.2.0.2, the PACKAGE PERFSTAT.STATSPACK package became invalid, I got these error when re-compile:
PACKAGE PERFSTAT.STATSPACK
On line: 3073
PL/SQL: ORA-00980: synonym translation is no longer valid
It is complaint the table v$dynamic_remaster_stats.
I ran below as sysdba, but it said the table is not exist
grant select on V_$DYNAMIC_REMASTER_STATS to perfstat;
didn't work But I still get the same error when compile PERFSTAT.STATSPACK
Please help
Thanks
George
** Please ignore this
I ran below as sysdba, but it said the table is not exist
It should be :