Access Keys:
Skip to content (Access Key - 0)

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?

IS&T Contributions

Documentation and information provided by IS&T staff members


Last Modified:

January 22, 2012

Get Help

Request help
from the Help Desk
Report a security incident
to the Security Team
Labels:
c-data-warehouse c-data-warehouse Delete
query query Delete
data data Delete
warehouse warehouse Delete
942 942 Delete
ora ora Delete
00942 00942 Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
Feedback
This product/service is:
Easy to use
Average
Difficult to use

This article is:
Helpful
Inaccurate
Obsolete
Adaptavist Theme Builder (4.2.3) Powered by Atlassian Confluence 3.5.13, the Enterprise Wiki