Error: ORA-00942: table or view does not exist

Error: ORA-00942: table or view does not exist

The above error commonly occurs while executing any SQL statement on database and this is because either the view or table we entered does not exist, or a synonym was used that is not allowed here , or a view was referenced where a table is required. To check what the problem is : just look after the spelling of the view / table name, or that an existing table or view name exists.

If this error occurred then firstly check  if the table exists in Oracle by using the following SQL statement:

SELECT *
FROM all_objects
WHERE object_type in ('TABLE','VIEW')
AND object_name = 'OBJECT_NAME';
If Not then Contact your database administrator to create a table that needs to be created.
Ebook Download
View all
Learn
View all
F11Research & Development, LLC