Database Tuning (MOSC)

MOSC Banner

after upgrade to 11.2.0.2 PERFSTAT.STATSPACK ORA-00980: synonym translation is no longer valid

edited Nov 12, 2010 5:49PM in Database Tuning (MOSC) 1 commentAnswered
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 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 :

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