My Oracle Support Banner

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

Last updated on JUNE 06, 2021

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.