DROP SYNONYM

How to Resolve ORA-01434: private synonym to be dropped does not exist

by Ed Chen
October 27, 2022October 17, 2022

ORA-01434 Tried to drop a private synonym, but it failed with ORA-01434. SQL> show user USER is "OE" SQL> drop synonym country; drop synonym country… Read More »

How to Resolve ORA-00980: synonym translation is no longer valid

by Ed Chen
September 15, 2021September 4, 2022

ORA-00980 We usually use synonyms to point to a base object that we don't own it. Let's see a case. SQL> conn oe/oe@orclpdb1 Connected. SQL>… Read More »