ALL_XML_TABLES

Description of the all XMLType tables that the user has privileges on

Columns
   ___________________________
 
   OWNER
      Owner of the table
   TABLE_NAME
      Name of the table
   XMLSCHEMA
      Name of the XMLSchema that is used for the table definition
   SCHEMA_OWNER
      Name of the owner of the XMLSchema used for table definition
   ELEMENT_NAME
      Name XMLSChema element that is used for the table
   STORAGE_TYPE
      Type of storage option for the XMLtype data