7 Replies Latest reply on Aug 31, 2016 3:29 PM by Gary Graham-Oracle

    SQL Developer view's are messed up

    CroutonP

      Newbie here.

      I loaded (unzipped) SQL Developer (4.1.3) months ago and have been using it without an issue for awhile.  Recently I came across an issue that has hindered me from working and Google hasn't found me an answer, so I'm turning to the professionals here.

      Something seems to be messed up with my views.  Other users are not seeing this, so I know it's my instance.  I have SQL developer loaded on a VM machine running Windows server 2008.

      So the issue:  When I click on a table, any table, and go to the Data tab, nothing shows, not even the headers.  The message log says "ORA-00904: 'ORA_ROWSCN': invalid identifier"

      Also, if I do a simple query to get the data, the output is garbled, for example:

       

      <table-Employee>

      Last_Name   |  First_Name  |   Middle  |   ID             |     Phone       |  Title       |  Status

      Smith            |  Joe               |     T        |   234567     |    555-6789  |   Boss     |     Active

       

      <query>

      SELECT *

      FROM Employee

       

      <output>

                                   Last_Name                      First_Name                  Middle

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

      ID

      ---------

      Phone

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

      Title

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

      Status

      ----------

                                            Smith                                   Joe                          T

      234567

                                   Last_Name                      First_Name                  Middle

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

      ID

      ---------

      Phone

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

      Title

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

      Status

      ----------

      555-6789

      Boss

       

                                   Last_Name                      First_Name                  Middle

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

      ID

      ---------

      Phone

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

      Title

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

      Status

      ----------

      Active

       

       

      That was a lot!  OK, let me know if you need more information from me, or as a Newbie if I messed something up.

      Thanks in advanced for any help

      -U