How Oracle Rename Synonymby Ed ChenOctober 7, 2022November 17, 2022Private 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 Oracle Rename Synonym
How to Resolve ORA-02030: can only select from fixed tables/viewsby Ed ChenMarch 30, 2022April 9, 2022ORA-02030 Tried to grant SELECT object privilege to an user, but it failed with ORA-02030. SQL> grant select on v$session to erpapp; grant select on… Read More »How to Resolve ORA-02030: can only select from fixed tables/views
How to Resolve ORA-00942: table or view does not existby Ed ChenMarch 23, 2019December 10, 20224 CommentsORA-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 »How to Resolve ORA-00942: table or view does not exist
How to Resolve ORA-03134: Connections to this server version are no longer supportedby Ed ChenFebruary 17, 2019December 10, 2022ORA-03134 As I mentioned in How to Resolve ORA-28040: No matching authentication protocol. ORA-28040 is not difficult to be solved if you were trying to… Read More »How to Resolve ORA-03134: Connections to this server version are no longer supported