Skip to Main Content

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 greyed out on left hand side, no data or SQL tab on right hand side

450441Mar 15 2011 — edited Mar 15 2011
SQLDeveloper 2.1.1 Oracle DB 10.2.0.4

Any existing tables are greyed out on the connections view under <schema><Tables>. Selecting the table gives a table tab on the right but it only has sub-tabs for columns, constraints, grants, statistics, triggers, dependencies, details, partitions, indexes - no data tab and no sql tab.

If I create a table logged in as that user and refresh the connections view, that table isn't greyed out and does have a data tab and an SQL tab.

If I then select one of the old tables so that it replaces the new table on the right - it now DOES have data and sql tabs. If I look at DBA_TABLES for old and new nothing obvious is different (apart from sizing info etc).

I'm a developer so I don't know too much about the inner workings of the database or what to look at. Any ideas?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2011
Added on Mar 15 2011
4 comments
912 views