3 Replies Latest reply: May 18, 2012 12:29 PM by Prashant Dixit RSS

    ORA-00942:Table or view does not exist

    Prashant Dixit
      Hi,


      Getting errors while deleting some tables from schema. Fail to delete tables in lowercase - check below (All other tables exists in Schema are working good and yielding to sql queries.

      And I've noticed that top two tables music and trade (Lowercase) are giving errors "ORA-00942: table or view does not exist" (music, trade)
      All others except these two are normal and are in Uppercase letters (PERSON, SALARY ...)


      SQL> select * from tab;

      TNAME TABTYPE CLUSTERID
      ------------------------------ ------- ----------
      music TABLE
      trade TABLE
      PERSON TABLE
      ORDERS TABLE
      SALARY TABLE
      EMP1 TABLE
      DEPT1 TABLE

      7 rows selected.

      SQL> select from music;*
      select * from music
      *
      ERROR at line 1:
      ORA-00942: table or view does not exist

      SQL> select from trade;*
      select * from trade
      *
      ERROR at line 1:
      ORA-00942: table or view does not exist

      SQL> select * from person; /* Working Good */
      SQL> set line 125

      SQL> /

      PID LASTNAME FIRSTNAME ADDRESS CITY
      ---------- --------------- --------------- -------------------- ---------- ----------
      7 KUMAR ASHIMA LAJPATNGR DELHI



      SQL> conn / as sysdba;
      SQL> purge recyclebin;

      Recyclebin purged.




      - Issue still persists even after purging the recycle bin connecting / as SYSDBA.

      Please Suggest.



      Thanks
      - Prashant Dixit

      Edited by: Prashant_Dixit on Apr 22, 2012 10:57 PM

      Edited by: Prashant_Dixit on Apr 22, 2012 10:59 PM
        • 1. Re: ORA-00942:Table or view does not exist
          Hoek
          Were the tables created using double quotes (the "-sign)?
          If so then retry:
          {code}
          select * from "music";
          {code}

          See:
          http://docs.oracle.com/cd/E11882_01/server.112/e26088/sql_elements008.htm#SQLRF51129
          for more explanation regarding quoted identifiers or nonquoted identifiers.
          • 2. Re: ORA-00942:Table or view does not exist
            sb92075
            Prashant_Dixit wrote:
            Hi,


            Getting errors while deleting some tables from schema. Fail to delete tables in lowercase - check below (All other tables exists in Schema are working good and yielding to sql queries.

            And I've noticed that top two tables music and trade (Lowercase) are giving errors "ORA-00942: table or view does not exist" (music, trade)
            All others except these two are normal and are in Uppercase letters (PERSON, SALARY ...)


            SQL> select * from tab;

            TNAME TABTYPE CLUSTERID
            ------------------------------ ------- ----------
            music TABLE
            trade TABLE
            SELECT * FROM "music";

            COPY & PASTE line above, then execute it
            • 3. Re: ORA-00942:Table or view does not exist
              Prashant Dixit
              Thanks Hoek.


              Issue Fixed