The Oracle database supports XML schema repository (XSR) in the database catalogs. The
contextual menu of a 
XML Schema Repository node in the tree from the
Data Source Explorer view contains the following actions:
Refresh- Performs a refresh for the sub-tree of the selected node.
- Register
- Opens a dialog box for adding a new schema file in the XML repository. To add an XML
Schema, enter the schema URI and location on your file system. Local scope means
that the schema is visible only to the user who registers it. Global scope means
that the schema is public. Note: Registering a schema may involve dropping/creating types. Hence you need type-related privileges such as DROP TYPE, CREATE TYPE, and ALTER TYPE. You need privileges to delete and register the XML schemas involved in the registering process. You need all privileges on XMLType tables that conform to the registered schemas. For XMLType columns, the ALTER TABLE privilege is needed on corresponding tables. If there are schema-based XMLType tables or columns in other database schemas, you need privileges such as the following:
- CREATE ANY TABLE
-
CREATE ANY INDEX
-
SELECT ANY TABLE
-
UPDATE ANY TABLE
-
INSERT ANY TABLE
-
DELETE ANY TABLE
-
DROP ANY TABLE
-
ALTER ANY TABLE
-
DROP ANY INDEX
