1 2 Previous Next 20 Replies Latest reply on Aug 21, 2018 1:31 PM by tvCa

    ORA-00942: table or view does not exist

    Athurumithuru

      Hi All,

       

      I'm getting 'ORA-00942: table or view does not exist' error when trying to insert some values. When I execute, select statements against the same table, it shows no errors. Pls help me to clear this confusion.

       

      insert into tmsp.SHIPMENT_REQUEST (SHIPMENT_REQUEST_SEQ) VALUES (1); --> ORA-00942: table or view does not exist

      select * from tmsp.SHIPMENT_REQUEST; --> show no errors

       

      SELECT owner

      FROM all_objects

      WHERE object_type IN ('TABLE','VIEW')

      AND object_name = 'SHIPMENT_REQUEST'; --> tmsp

       

      Thanx

      Athurumithuru.

        1 2 Previous Next