This content has been marked as final. Show 24 replies
Are you connected with the objects owner?1 person found this helpful
If not, you need to use Other Users on the tree view.
through tnsnames.ora entry i have connected. Do you mean physically mapping the drive where DB reside?
If this is the case then i need to figure this out.
Edited by: user635322 on Oct 31, 2008 1:21 PM
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.
I meet the same problem.'Loading Tables' and then a dialog 'Error encountered: connection reset vendor code 17002'
The last question you posted in a complete different problem from the original one. Next time please open a new post.
If this happens, right click on your database connection, go to properties and if SID is selected with your database name, change it to service name with your database name.
Then do not forget to Test your connection.
Edited by: FML0 on Dec 13, 2008 3:23 PM
I am having the same problem. I cannot view the tables of certain (but not all) users.
Again, please do not hijack threads for different problems, post a new one and indicate how you are accessing them.
I have the same problem..
I can't see the tables on the left pane where the views and tables are listed.
I am not the owner of the tables, nor I have administration privileges for these
On the other hand I can query this on the sql editor and it displays all the tables
select object_name from all_objects
where owner = '[USER]'
Please help... undoubtly something is misconfigures in the SQLDeveloper version 1.5.1 (which I am using)
Guys, you do know only your own tables/views (and optionally synonyms) are listed under the main node, don't you? Other users should be accessed through the Other Users node...
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.
Hope that helps,
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.
Hope that helps,
all tables are same grants. Why I can see all tables in TOAD, but don't see these in SQL Developer? This is problem for me. Petr