SQL Developer

I am using Sqldeveloper 3.0.04 on a Windows 7 system. I have a basic connection to an Oracle database on another server. I am new to both Sqldeveloper and Windows 7.

When I create a query using the graphical user interface to drag and drop tables from the Navigator onto the Query Builder tab, then save the query to a file on my hard drive, the table's columns are not displayed when the query is re-opened later for edit. The diagram correctly shows the table names above, but not the column names; the previously selected columns do re-appear on the grid below. I cannot modify the query without the columns being displayed for each table in the diagram.

As a workaround, I found that if I click on the Worksheet tab and copy and paste the query statements to a new Worksheet, the tables and their columns are correctly displayed on the new Query Builder tab.

So the symptom seems to be that Query Builder is not refreshing the graphical table diagram for a saved query, but can do so for a new query. How can I get the diagram on the Query Builder tab to be refreshed and complete when a saved query is re-opened ?

Edited by: melba on Feb 28, 2012 5:07 PM
I also tried changing the Tools > Preferences > Database > ObjectViewer setting to "Automatically Freeze Object Viewer Windows", but that did not work for me.