When I open "Tools->Monitor Sessions..." for a DB 18.104.22.168.0 I get the following error:
An error was encountered performing the requested operation:
ORA-00904: "SQL_ID": invalid identifier
00904. 00000 - "%s: invalid identifier"
Vendor code 904
This didn't happen to me in SQLDeveloper 3.2 and before. Anyone got an idea why that might happen?
The documentation for 4.0 EA1 says it is certified for "Oracle9i (22.214.171.124 and later)".
And while we are at it:
The popup which opens when you do a "SHIFT-F4" on a table-name just gives you error-messages when opening the "flashback" and "details"-tabs.
For "flashback" it's ORA-00933 followed by ORA-00904, and for "details" it's just the ORA-00904.
This already didn't work in 3.2 though.
Thanks in advance
I would report this bug in SQLDevelopers bugtracker if there was one.
The "SQL Developer Exchange" doesn't seem to be the right place for bugs though. So anyone knows where to report this?
Extended support for 9iR2 ended in July 2010, I don't believe you've be able to open a ticket with My Oracle Support.
What you can do right now, is copy the Sessions report down to the User folder and change/fix the queries.
Thanks for your tip on changing the built-in reports! I will see what I can do with it.
I know that 9iR2 is not supported anymore. It's just that the documentation says that SQLDeveloper 4 is certified for it!