How Oracle Rename View
To rename a view, we should RENAME TO statement to rename it, but you have to login as the object's owner. For example: SQL> show… Read More »How Oracle Rename View
View
Oracle RENAME Statement
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 »Oracle RENAME Statement
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