Synonym

How to Resolve ORA-01432: public synonym to be dropped does not exist

by Ed Chen
October 28, 2022October 17, 2022

ORA-01432 Tried to drop a public synonym, but it failed with ORA-01432. SQL> drop public synonym country; drop public synonym country … Read More »

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 Oracle Rename Synonym

by Ed Chen
October 7, 2022November 17, 2022

Private Synonym To rename a private synonym, we should RENAME TO statement to rename it, but you have to login as the object's owner. For… Read More »

How to Resolve ORA-00995: missing or invalid synonym identifier

by Ed Chen
July 22, 2022October 1, 2022

ORA-00995 ORA-00995 means that the synonym name you specified in the statement is either invalid or not found, you should make sure the synonym identifier… 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 »

You don't have to export and import public synonyms by data pump, you can compose the creation statements by querying ALL_SYNONYMS:: [oracle@primary01 oracle]$ vi compose_create_or_replace_synonym.sql… Read More »