My Oracle Support Banner

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.

Symptoms

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:

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.