Anderson means what user are you connect to the the database as, and is that user the owner of the tables? You may be able to see tables which your user doesn't own through synonyms. If that is the case, then look in the Other Users tab to find the user who owns the tables.
Using SQL Developer, I log in using the owner user id and password. I can see all but one of my materialized views. It was definitely created by the user id I'm logged in as. A query of user_objects in sql+ shows all MVs, including the one that's missing in SQL Developer. If I log in using the same credentials in TOAD, the MV is displayed in the current schema, as I'd expect. The super weird thing is that if I use the previous version of SQL Developer, I see that MV! Any thoughts?
Edited by: email@example.com on Feb 25, 2009 9:19 AM
If it has the Generated flag set, it won't show. You can force that off, or change the query of the Table node or add your own version of the Table node through a User Defined XML Extension. I'm pretty sure the team accepted this as bug and will address it in a future version.
Hi, I have same problem with tables. In TOAD I see all tables in <other user> schema, but in SQL Developer I doesn't see all tables (logon to both applications with the same username and password). Please, how can I create own table node or edit table node query?
Ad second, I have problem with connection type LDAP: SQL developer doesn't use ldap.ora (not appear list of LDAP servers).
Thanks for Your help, Petr
If other users' tables aren't listed under their name in the Other Users node, you lack privileges on them.
If you just want to list them without granting privileges on them, you need the select_catalog_role and/or select any dictionary.