Dropping Public Synonyms on Old Edition Fails With Errors 'ORA-04045: errors during recompilation/revalidation' and 'ORA-00980: synonym translation is no longer valid'
(Doc ID 2967533.1)
Last updated on AUGUST 16, 2023
Applies to:EBS on Oracle Cloud: Provisioning and Administration - Version 12.1.3 and later
Information in this document applies to any platform.
Dropping public synonyms from old editions, which are already dropped on the later/current edition, fails with errors "ORA-04045" and "ORA-00980".
Below error occurs (on the console) when drop command is executed:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document