Skip to Content
0
Former Member
Nov 10, 2010 at 02:11 PM

DB verify structure of tables and indexes job failed

396 Views

Hi,

DB verify tables and indexes job failed in our SAP system.The log details in DB14 shows as mentioned below:

BR0301E SQL error -980 in thread 2 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SYS"."WRH$_DB_CACHE_ADVICE" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-00980: synonym translation is no longer valid

BR0893E Validating structure failed for table/cluster SYS.WRH$_DB_CACHE_ADVICE

BR0280I BRCONNECT thread 1: time stamp: 2010-11-07 23.15.57

BR0301E SQL error -980 in thread 1 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SYS"."WRH$_DLM_MISC" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-00980: synonym translation is no longer valid

BR0893E Validating structure failed for table/cluster SYS.WRH$_DLM_MISC

BR0280I BRCONNECT thread 2: time stamp: 2010-11-07 23.16.04

BR0301E SQL error -980 in thread 2 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SYS"."WRH$_FILESTATXS" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-00980: synonym translation is no longer valid

BR0893E Validating structure failed for table/cluster SYS.WRH$_FILESTATXS

BR0280I BRCONNECT thread 1: time stamp: 2010-11-07 23.16.08

BR0301E SQL error -980 in thread 1 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SYS"."WRH$_INST_CACHE_TRANSFER" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-00980: synonym translation is no longer valid

BR0893E Validating structure failed for table/cluster SYS.WRH$_INST_CACHE_TRANSFER

BR0280I BRCONNECT thread 2: time stamp: 2010-11-07 23.16.15

BR0301E SQL error -980 in thread 2 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SYS"."WRH$_LATCH" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-00980: synonym translation is no longer valid

BR0893E Validating structure failed for table/cluster SYS.WRH$_LATCH

BR0280I BRCONNECT thread 1: time stamp: 2010-11-07 23.16.19

BR0301E SQL error -980 in thread 1 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SYS"."WRH$_LATCH_CHILDREN" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-00980: synonym translation is no longer valid

BR0893E Validating structure failed for table/cluster SYS.WRH$_LATCH_CHILDREN

BR0280I BRCONNECT thread 2: time stamp: 2010-11-07 23.16.27....................................................

We are using Oracle 10.2.0.2 and SAP version ECC 6.0

Please help on this issue..

Thanks in advance

Veera