How Oracle Rename Synonym
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 Oracle Rename Synonym
Synonym
How to Resolve ORA-02030: can only select from fixed tables/views
ORA-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 exist
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 »How to Resolve ORA-00942: table or view does not exist
How to Resolve ORA-03134: Connections to this server version are no longer supported
ORA-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