Public 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 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 »

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 »

How to Resolve ORA-00942: table or view does not exist

by Ed Chen
March 23, 2019May 15, 2023
4 Comments

ORA-00942 ORA-00942 means that SQL engine found no table or view in your usable scope. In other words, table or view does not exist. The… Read More »

JavaScript is not enabled. Please enable it and reload the page.

Public Synonym

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

How Oracle Rename Synonym

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

Get DDL from ALL_SYNONYMS

How to Resolve ORA-00942: table or view does not exist