Database Administration (MOSC)

MOSC Banner

numerous public synonyms are invalid

edited Dec 6, 2024 3:45PM in Database Administration (MOSC) 4 commentsAnswered

After migrated db19c SE database(non-container) to cloud - over 1000 public synonyms became invalid. Note: it is SDE instance in Oracle.

Is it a better way to recompile 1000 objects then :

SQL> alter public synonym 'synonym name' compile;

How to avoid this issue when migrate?

Pls help.

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