3 Replies Latest reply: Sep 26, 2013 11:38 PM by Gary Graham-Oracle RSS

    Table does not exist

    user8093006


      Why does SQL Developer insist that a table does not exist wher it's clear as day that it DOES exist ?

      I am trying to run an SQL SELECT which was generated by SQL DEVELOPER by dragging the table name from the object tree into the SQL work area - so

      SQL DEVELOPER wrote every single characteter of the SQL statement - and when I run it I get "Table does not exist"

      It can't even find it's own table.

        • 1. Re: Table does not exist
          rp0428

          user8093006 wrote:

           


          Why does SQL Developer insist that a table does not exist wher it's clear as day that it DOES exist ?

          I am trying to run an SQL SELECT which was generated by SQL DEVELOPER by dragging the table name from the object tree into the SQL work area - so

          SQL DEVELOPER wrote every single characteter of the SQL statement - and when I run it I get "Table does not exist"

          It can't even find it's own table.

          That generally means that the user executing the query does not have the needed permissions for the DML being run.

           

          Post the query you are trying to execute and tell us who owns the tables and who is the user executing the query.

          • 2. Re: Table does not exist
            SahilBatra

            Hi,
            The possible reasons for the same could be the permission issue.
            You can use this query to get the details(owner, schema etc.) for the given table.

             

            select *

            from all_objects

            where object_type in ('TABLE','VIEW')

            and object_name = 'OBJECT_NAME';

             

            Plus, this error can occur even if you are using an application deployed on the server to access your database, even if you are refer the correct schema. The main point being that how Oracle database distinguishes permissions granted via roles than permissions granted directly.

            Check the following queries


            Create Table TABLE_A
            Create Role READ_ONLY
            Grant Select on TABLE_A to READ_ONLY
            Grant READ_ONLY to USERXYZ


            AND


            Grant Select on TABLE_A to USERXYZ

             

             

            Choose what is apt for you.

             

            Hope it helps!!

            • 3. Re: Table does not exist
              Gary Graham-Oracle

              Hi,

              user8093006 wrote:

               

              I've got an SQL statement of around 100 lines with something like a DOZEN tables in it , and as a diagnostic all poor old Orable can

              manage is "Table Does Not Exist" . No line. No Column. No Table Name.

               

              You have not posted any code as previously requested, nor even stated which version of the product you use.  The ability to toggle on line numbers in the left gutter of a SQL Worksheet and see the script line and column numbers related to an error in the Query Result / Script Output tab have been available since at least version 1.2.1.  In early versions line and/or column numbers referenced in the error message may have been off by 1.

               

              The current production version (3.2.2) and latest early adopter version (4.0 EA2) continue support for those two features. If you do not see it working properly in one or both of these recent versions, please post a reproducible test case if you wish help.

               

              Regards,

              Gary

              SQL Developer Team