Unable To See XML DB Folders In SQLDeveloper For Some Databases (Doc ID 1474368.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Using SQL*Developer to view the folders within the XDB Repository and within SQL*Developer it will appear as though no folders exist even if they do exist.

This issue is only with some databases, most of the other databases will display the proper folders.

The following query is what SQL*Developer uses to retrieve available folders. It can be used as a test within SQL*Plus.


If the above query is run in SQL*Plus and "no rows selected" is returned, this means no data is found.
Since this is the same query that is used by SQL*Developer, if no data is found when run in SQL*Plus it makes sense that SQL*Developer doesn't display any data either.

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