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

Oracle RENAME Statement

by Ed Chen
October 3, 2022October 20, 2022

RENAME Syntax For convenience, Oracle provide RENAME statement to change some types of object's name. The syntax is as: RENAME old_name TO new_name; There're only… Read More »

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

by Ed Chen
March 23, 2019February 20, 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 »