PL/SQL (MOSC)

MOSC Banner

PACKAGE PERFSTAT.STATSPACK ORA-00980: synonym translation is no longer valid

edited Nov 14, 2010 7:00PM in PL/SQL (MOSC) 6 commentsAnswered
Hi,

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 complain the table v$dynamic_remaster_stats.

I ran below as sysdba, but it said the table is not exist

 grant V_$DYNAMIC_REMASTER_STATS to perfstat;
grant V_$DYNAMIC_REMASTER_STATS to perfstat
      *
ERROR at line 1:
ORA-01919: role 'V_$DYNAMIC_REMASTER_STATS' does not exist.

Please help

Thanks

George

PACKAGE PERFSTAT.STATSPACK
On line:  3073
PL/SQL: ORA-00980: synonym translation is no longer valid

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center