In Oracle SQL Developer some Objects (e.g. Tables) are not Displayed in the Navigator (Doc ID 364055.1)

Last updated on MAY 29, 2015

Applies to:

Oracle SQL Developer - Version 1.2.1 to 1.5.4
Information in this document applies to any platform.

Symptoms

***Checked for relevance on 11-Apr-2011***

In Oracle SQL Developer, some objects (e.g. tables) under particular user / schema are not displayed in the tables listing.

In SQL*Plus, the objects are listed fine when issuing a SQL statement like:

SQL> SELECT owner, object_type, object_name FROM all_objects 
WHERE object_type='TABLE' AND owner='<MYUSER>'
/

If a connection is made to another database instance via Oracle SQL Developer the objects may be displayed fine.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms