View

How to Resolve ORA-01702: a view is not appropriate here

by Ed Chen
June 27, 2023August 25, 2023

ORA-01702 Tried to create an index, but it failed with ORA-01702. SQL> create index emp_salary on happy_employees (salary); create index emp_salary on happy_employees (salary) … Read More »

How Oracle Rename View

by Ed Chen
October 10, 2022November 17, 2022

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 Table

by Ed Chen
October 4, 2022May 26, 2023

You can either using SQL statement or GUI tools to rename a table, depending on your requirement. Table Rename by SQL Statement Table Rename by… 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-02030: can only select from fixed tables/views

by Ed Chen
March 30, 2022May 12, 2023

ORA-02030 Tried to grant SELECT object privilege of V$SESSION to an user, but it failed with ORA-02030. SQL> grant select on v$session to erpapp; grant… 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.