ORA-00942: table or view does not exist
In the case you encounter the following error message: a table or view entered does not exist, or unauthorized synonym was used, or an expression of view was used instead of a table name.
YOu must verify the following items:
- the name of the view or the tables used
- that name of a view is used instead of a table name
- the name of the view or the table exists.
To verify the existence of view, table or synonym:
SELECT * FROM DBA_TABLES WHERE TABLE_NAME = 'table_name';
SELECT * FROM DBA_SYNONYM WHERE SYNONYM_NAME = 'synonym_name';
SELECT * FROM DBA_VIEWS WHERE VIEW_NAME = 'view_name';
Note:
In the case that the table needs to be created or if user or application privileges are needed to access the table , please scontact the database Administrator.
Cannot view hotmail webpage