Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tables/views/Procedures/functions etc are not showing up in tree view, but can execute select * on d

2933934Apr 20 2015 — edited Apr 20 2015

There was one other thread from years ago detailing this same problem. The only clue was to check whether select all privs were enabled for the user on dba_objects. They are for the user accessing the system. In fact, all tables/views/procs/funcs can be viewed in the tree view of DBVisualizer. For whatever reason, OSD does not show anything.

I'd appreciate any clues! Thank you!

CantSeeTablesViewsProcsFuncsInOSD.png

OSD Version Version 4.1.0.18

OS: Windows 7/64

Java: 1.8.0

Connecting to Oracle 11g 11.2.0.3.0

Comments

Gary Graham-Oracle

You do not say which version of SQL Developer is in use, which JDK, which OS, whether Thin or OCI/Thick JDBC driver, etc., etc.  However, assuming recent versions not subject to old, known bugs, you may just need to read this blog post...

http://www.thatjeffsmith.com/archive/2013/03/why-cant-i-see-my-tables-in-oracle-sql-developer/

1 person found this helpful
2933934

Thank you, Gary.

I updated the post with the version info. I did not explicitly install this JDBC driver, so whatever the OSD came with?  Unless it is using whatever is installed on my machine, in which case would be the thin driver.

I did check out that post, and I appreciate you sharing it. I did click the 'include synonyms' filter, but behavior remained unchanged.

I would prefer to use OSD, and that is what our dev team was expecting to use, but we just can't see the information.  We are using an ID that does not 'own' those tables, per se.  But, why would DBVisualizer show these tables, when OSD does not?

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 18 2015
Added on Apr 20 2015
#sql-developer
2 comments
1,026 views