1 Reply Latest reply on May 21, 2014 7:06 PM by thatJeffSmith-Oracle

    Using DESC in other schema

    Sebastian4711

      After upgrading SQL Developer without changing ORACLE Server I have the following problem.

       

      When I use DESC (shorthand for DESCRIBE) on a table in another schema after switching schema via

       

      ALTER SESSION SET CURRENT_SCHEMA = OTHER_SCHEMA;

       

      I only receive this result:

       

      desc OTHER_SCHEMA.MYTABLE;

       

      ERROR:                                                 

      -------------------------------------------------------

      FEHLER: Objekt MYTABLE ist nicht vorhanden

       

      When I type the following I receive my result as expected:

       

      desc OTHER_SCHEMA.MYTABLE

       

      It is reproducible with different Users and on different Databases with the following version:

       

      Version SQL-Developer: Version 4.0.2.15

      Version Oracle: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

       

      Regards

      Sebastian

        • 1. Re: Using DESC in other schema
          thatJeffSmith-Oracle

          i just tried...

           

          ALTER SESSION SET CURRENT_SCHEMA = SH;

           

          desc scott.emp

           

          and

           

          desc scott.emp;

           

          Got back the sqlplus style description as expected for both scenarios

           

          I think what you mean is you're doing this:

           

          desc emp

           

          And you get back the error. The script engine isn't supporting that workflow, and that could be a bug. In the meantime, a workaround would be to use Shift+F4 to do a 'sql developer' describe.