SQL Developer

As of recently, SQL Developer 1.0.0.14 “Connections tab”, running on a Windows machine, allowed us to view all tables within all users schema's with each of our 9i R2 (Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production) databases which are running on Solaris Unix. One of our databases required that it be rebuilt and an export/import was used in part to complete this. Now however, SQL Developer's “Connections tab” can only view certain schema's within that database, and not others. It does not even see tables in the schema of the user logged in.

All filters within SQL Developer are selected to display or show all. Some or all indexes, packages, procedures and others (not sure about views) are displayed as expected. In databases that were not rebuilt, SQL Developer still displays all tables in all schemas as it had using the same SQL Developer “Connections tab”. I can not find any differences in roles, grants, permissions or anything else between the databases as far as user setup and this appears to be a problem with all users.

I can see the “missing” tables with other products, such as OEM. I can see the “missing” tables through the "Reports" tab of the same SQL Developer 1.0.0.14 version. Interestingly enough, the “missing” tables/schemas can also be seen using the older Oracle Project Rapture 1.0.0.09 version. I also have found that tables created after the rebuild are displayed correctly, whether the tables were created in SQL Developer or SQL Plus.

I have reinstalled SQL Developer and have done everything else that I can think of. Any ideas?