Q: I'm trying to run a query and I get "ORA-00942 Table or view does not exist." What's wrong?
Answer
This means that the query you're running is trying to access a table for which you do not have authorization. You need to request and be granted access authorization from the providers of the data before you can run this query.
One way to find out if you have access authorization for a table is to click once in the table to make it active, then choose Detail View from the DataModel menu. If you have access, a sampling of data will be displayed in the window. If you don't have access, the window will be empty. To return to the list of fields for the table, choose Structure View from the DataModel menu.
This article's original title was: I'm trying to run a query and I get "ORA-00942: Table or view does not exist." What's wrong?