ORA-00942 Table or View Does Not Exist Oracle Error库存- 00942表或视图不存在Oracle错误

Sometime when you compile an object or package or view in Oracle, or execute some PL/SQL statements on Oracle table, or when running an Oracle program or application, the following error my occurs:有时当您编译一个对象或包装或查看在Oracle中，或执行一些PL / SQL的声明，甲骨文表，或当运行一个Oracle程序或应用程序，下面的错误，我发生：

ORA-00942: table or view does not exist库存- 00942 ：表或视图不存在

The cause or reason for ORA-00942 error message is because of Oracle tries to execute an SQL statement that references a table or view that either does not exist, or because of a synonym that is not allowed here was used, or because of you do not have access rights to the particular object.原因或理由库存- 00942错误讯息，是因为甲骨文试图执行一个SQL语句参考表或认为要么不存在，或者因为一个同义词是不容许在这里用，或因为你这样做没有访问权限的特定对象。 Other possible cause is that the table or view belongs to another schema and you didn’t reference the table by the schema name, or a view was referenced where a table is required.其他可能的原因是，该表或检视属于另一个架构和你没有参考表所架构的名称，或有一种意见是引用凡表是必需的。

Depending on what’s the cause of the problem, there are several resolutions or remedies to resolve this error.根据对什么样的问题的原因，有几项决议或补救措施，要解决这个错误。 And due to several possible reasons that may cause the error, there are several actions or steps that you can take to identify where is the error and take the appropriate workaround or solution.由于几个可能的原因可能造成的错误，有几个行动或步骤，您可以采取确定哪些地方是错误，并采取适当可行方案或解决办法。

1. Check existing user tables and views if they exists in Oracle by querying the data dictionary by executing the following SQL statement:检查现有的用户表和意见，如果他们存在于甲骨文藉由查询数据字典执行以下SQL语句：

   select *选择*
   from all_objects从all_objects
   where object_type in (’TABLE’,'VIEW’)如果object_type在（ '表' ， '查看' ）
   and object_name = ‘ OBJECT_NAME ‘;和object_name = ' object_name ' ;

   Replace OBJECT_NAME with the name of the table or view that you want to verify its existence.取代object_name与表的名称或认为您要验证它的存在。

   If this error occurred because the table or view does not exist, take the following actions:如果这发生错误，因为该表或视图不存在，采取以下行动：

   • Check and ensure that the spelling of the table (does not misspell) or view name is correct.检查并确保拼写表（不拼错）或视图名称是正确的。
   • Check and ensure that a view is not specified where a table is required.检查并确保看法是没有指明如果一个表是必需的。
   • If no such table or view exists, create the table or view, or use another table or view.如果没有这样的表或视图存在，创建表或视图，或使用另一个表或检视。
2. If the table or view exists, check and verify if the user has the necessary permissions and rights to read and access (ie select) from the table, as certain privileges may be required to access the table.如果表或视图存在，检查和验证，如果用户有必要的权限和权利的阅读和获取（即选择）从表中，由于某些特权，可能需要访问该表。 In this case, you will need to have the owner of the table or view, or a Oracle DBA to grant the appropriate privileges, permissions or rights to this object.在这种情况下，您将需要有拥有该表或视图，或一甲骨文公司名义运作给予适当的特权，权限或权利到这个对象。

   Note that when selecting from a system view (such as v$session) the privilege or access rights to select from the view must be granted to the user directly and not via a role.请注意，当选择从制度的看法（如为V元，会议）的特权或访问的权利，选择从视图必须给予用户直接而不是通过一个角色。 This is the case if you can select from the view without problem but then get this error when trying to create a view on it.在这种情况下，如果您可以选择从视图没有问题，但当时得到这个错误时，试图建立一个的看法。

3. If the table or view exists but is in a different schema from the current schema where the SQL is executing (in other word, the table doesn’t own by you, but owned by other user), the ORA-00942 error will return too.如果表或视图存在，但是在一个不同的模式从目前的架构下SQL是执行（在其他字，该表没有自己的你，但所拥有的其他用户） ，电脑- 00942错误将返回太。 Resolve this by explicitly reference the table or view by specifying the schema name, ie schema_name.table_name.解决这个问题，明确参考表或视图指定架构名称，即schema_name.table_name 。

IMPORTANT : This is a machine translated page which is provided "as is" without warranty. 重要说明 ：这是一个机器翻译网页是“按原样”提供的担保。 Machine translation may be difficult to understand.机器翻译可能很难理解。 Please refer to请参阅 original English article英文原版的文章 whenever possible.只要有可能。

Share and contribute or get technical support and help at分享和贡献，或取得技术的支持和帮助，在 My Digital Life Forums 我的数字生活论坛 . 。

Related Articles相关文章

• ORA-02449 Oracle Drop Table Error库存- 02449甲骨文下拉表错误
• Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error创建，添加或分裂Oracle数据库分区失败，库存- 14080错误
• Oracle Database Import Error 3113/3114 Oracle数据库的进口错误三千一百一十四分之三千一百十三
• Oracle ORA-14074 Create or Add New Partition Fails Error甲骨文库存- 14074创建或添加新的分区失败的错误
• ORA-01502 Oracle Index in Unusable State库存- 01502甲骨文指数在使用的国家
• View and Retrieve Oracle Database Link Details查看和检索Oracle数据库的连接细节
• Oracle PL/SQL ORA-00947 Not Enough Values Error甲骨文PL / SQL的库存- 00947没有足够的价值观错误
• Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error甲骨文库存- 01658无法建立初步的程度，为部分在表错误
• Manual and Clean Uninstall Oracle for Windows手册和干净的卸载甲骨文为Windows
• ORA-25153 Temporary Tablespace is Empty Error in Oracle库存- 25153临时表是空的错误，在Oracle

This entry was posted on Thursday, January 11th, 2007 at 6:03 pm and is filed under 此项目被张贴在周四， 2007年1月11日在下午6时03分，并提交下 Databases 数据库 . 。 You can follow any responses to this entry through the 您可以按照任何的反应，此项目通过 RSS 2.0 2.0 feed. 喂养。 You can 您可以 leave a response 留下的回应 , or ，或 trackback Trackback跟踪 from your own site. 从你自己的网站。