8. ORA-00942 table or view does not exist
if you faces this error, check this 4 cases.
- Database not connected.
- Table not authorized.
- Spelling error or indeed table does not exist.
- Naming the owner in front of the table and SELECT.
Ex1)
- Reconnect to the database.
Ex2)
- Ask your DBA for permission.
Ex3)
- SELECT * FROM TABEL;
-> SELECT * FROM TABLE;
Ex4)
- SELECT * FROM owner.TABLE
Written on September 13, 2017