Running a query in the Editor gave the error: ORA-00942:table or view does not exist. (4285600)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Running a query in the Editor gave the error: ORA-00942:table or view does not exist.
Description

Running a query in the Editor gave the error: "ORA-00942: table or view does not exist".
Cause
Resolution

RESOLUTION 1:
Qualify the table with the correct schema. For example, SELECT * from <schema>.<table_name>.
RESOLUTION 2:
Check in the Schema Browser | Tables under the schema that is being queried to make sure the table does exist.
RESOLUTION 3:
Go to Search | Object Search in Toad and see if the table exists anywhere in any schema on the database.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title