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. 從你自己的網站。