ORA-00942: table or view does not exist
Oracle PL/SQL error message: ORA-00942: table or view does not exist.
Cause:
The table or view entered does not exist.
Solution:
Check if you write the correct name of the table or view.
Check if the table or view name exists in the database.
Check if the user that you are connected has privileges on table or view.
If the table or view exists in another schema, then check if you write the correct schema name or check for privileges.
Example:
select * from abc; SQL Error: ORA-00942: table or view does not exist