DBA_XML_TABLES

Oracle 11gR1

DBA_XML_TABLES describes all XML tables in the database. Its columns are the same as those in ALL_XML_TABLES.

Related Views

· ALL_XML_TABLES describes the XML tables accessible to the current user.

· USER_XML_TABLES describes the XML tables owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)		Owner of the XML table
TABLE_NAME	VARCHAR2(30)		Name of the XML table
XMLSCHEMA	VARCHAR2(700)		Name of the XML Schema that is used for the table definition
SCHEMA_OWNER	VARCHAR2(30)		Owner of the XML Schema that is used for the table definition
ELEMENT_NAME	VARCHAR2(2000)		Name of the XML SChema element that is used for the table
STORAGE_TYPE	VARCHAR2(17)		Storage option for the XMLtype data: · OBJECT-RELATIONAL · BINARY · CLOB
ANYSCHEMA	VARCHAR2(3)		If storage is BINARY, indicates whether the column allows ANYSCHEMA (YES) or not (NO), else NULL
NONSCHEMA	VARCHAR2(3)		If storage is BINARY, indicates whether the column allows NONSCHEMA (YES) or not (NO), else NULL

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