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