DBA_XML_SCHEMAS

Oracle 11gR1

DBA_XML_SCHEMAS describes all registered XML schemas in the database. Its columns are the same as those in ALL_XML_SCHEMAS.

Related Views

· ALL_XML_SCHEMAS describes the registered XML schemas accessible to the current user.

· USER_XML_SCHEMAS describes the registered XML schemas owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)		Owner of the XML schema
SCHEMA_URL	VARCHAR2(700)		Schema URL of the XML schema
LOCAL	VARCHAR2(3)		Indicates whether the XML schema is local (YES) or global (NO)
SCHEMA	XMLTYPE		XML schema document
INT_OBJNAME	VARCHAR2(4000)		Internal database object name for the schema
QUAL_SCHEMA_URL	VARCHAR2(767)		Fully qualified schema URL
HIER_TYPE	VARCHAR2(11)		Type of hierarchy for which the schema is enabled: · NONE · RESMETADATA · CONTENTS
BINARY	VARCHAR2(3)		Indicates whether the XML Schema is registered for binary encoding usage (YES) or not (NO)
SCHEMA_ID	RAW(16)		Opaque schema identifier (16 bytes)
HIDDEN	VARCHAR2(3)		Indicates whether the XML Schema has been deleted in hidden mode (YES) or not (NO)

Note:

You can check the contents of ALL_XML_SCHEMAS and ALL_XML_TABLES views to check if XDB is being used in the database. If there is anything there which is owned by any user other than XDB then you may be using the XDB feature.

You may see following standard schemas under EXFSYS, MDSYS, ORDSYS, and SYS, e.g. -

OWNER SCHEMA_URL
---------- --------------------------------------------------------------------
EXFSYS http://xmlns.oracle.com/rlmgr/rclsprop.xsd
EXFSYS http://xmlns.oracle.com/rlmgr/rulecond.xsd
MDSYS http://www.opengis.net/cartographicText.xsd
MDSYS http://www.opengis.net/gml/feature.xsd
MDSYS http://www.opengis.net/gml/geometry.xsd
MDSYS http://www.w3.org/1999/xlink/xlinks.xsd
MDSYS http://xmlns.oracle.com/spatial/georaster/georaster.xsd
ORDSYS http://xmlns.oracle.com/ord/meta/dicomImage
ORDSYS http://xmlns.oracle.com/ord/meta/exif
ORDSYS http://xmlns.oracle.com/ord/meta/iptc
ORDSYS http://xmlns.oracle.com/ord/meta/ordimage
ORDSYS http://xmlns.oracle.com/ord/meta/xmp
SYS http://xmlns.oracle.com/streams/schemas/lcr/streamslcr.xsd

These are standard schemas which relate to Oracle Intermedia EXIF metadata, Oracle GEORASTER, EXFSYS, Oracle Locator components and may appear in the list if you have any of these components installed. These can easily be recreated by running the standard supplied scripts.

Metalink Note: 558834.1: How To Re-register XML Schemas After XDB Has Been Re-installed?

Oracle data dictionary views