ORA-00980 during ValidStruct

[Former Member]

Hi Oracle-experts!

After ValidStruct job I get the following errors:

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

'ANALYZE TABLE "SYS"."STREAMS$_APPLY_SPILL_MSGS_PART" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-00980: synonym translation is no longer valid

BR0893E Validating structure failed for table/cluster SYS.STREAMS$_APPLY_SPILL_MSGS_PART

Can some one help me to solve this error?

[Former Member]

Hello,

What is your Oracle release?

If you are at 10.2.0.1 then you have to upgrade to the latest 10.2.0.4, if you are already in the correct release then follow the note

provided in the previous post.

Regards,

Yoganand.V

[peter_dzurov]

Please check Note 650796 - Composite Note: ORA-00980