This discussion is archived
3 Replies Latest reply: May 18, 2012 10:29 AM by PrashantDixit RSS

ORA-00942:Table or view does not exist

PrashantDixit Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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
    PrashantDixit Newbie
    Currently Being Moderated
    Thanks Hoek.


    Issue Fixed

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points