SQL Error: Ora-00942 Table or View Does Not Exist

Oracle ORA-00942: table or view does not exist when it exists

It seems that case matters. What is the result of

select * from "Country";

It appears that someone created table using double quotes and mixed case (which is - in Oracle - a bad idea because you'll always have to reference it using double quotes and never fail in correctly spelling it.

ORA-00942 error is generating while creating a view

My issue has been resolved. :-)

I have made the following changes,

FROM
        hfdora.energization_info, 
        hfdora.trigger_info trigger_info_A,
        hfdora.trigger_info trigger_info_B, 
        hfdora.oms_consumer

Now the same view is created for the user cis.

ORA-00942: table or view does not exist 00942. 00000 - table or view does not exist

You have just used the wrong table name; your table is price_table, not pricelist:

SELECT pno, s.COLUMN_VALUE prices
from price_table p,TABLE(p.prices) s
/

       PNO     PRICES
---------- ----------
         1          2
         1          3
         1          4
         2          2
         2          3
         2          4
         3          2
         3          3
         3          4

ALTER TABLE ADD field getting ORA-00942 error

This was a permissions issue: I did not use the owner of the table to alter the table. Switching to a connection with those credentials fixed the issue.

PL/SQL: ORA-00942: table or view does not exist. Inside Function

The table you're selecting from belongs to user hawk.

User, which uses the function, should be granted the SELECT privilege (on that table). I presume that you did that (as SELECT itself works OK, but not as part of a function) - via some role. However, that won't work - you should grant the privilege directly to user, not via role.

---

Related Topics