numerous public synonyms are invalid
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.