Oracle Database Contextual Menu Actions

General Contextual Menu Actions

For relational databases, the following general actions are available in the contextual menu of the Data Source Explorer view, depending on the node in which it is invoked:

Refresh: Performs a refresh on the selected node.
Disconnect (available on Connection nodes): Closes the current database connection. If a table is already open, you are warned to close it before proceeding.
Configure Database Sources (available on Connection nodes): Opens the Data Sources preferences page where you can configure both data sources and connections.
Edit (available on Table nodes): Opens the selected table in the Table Explorer view.
Export to XML (available on Table nodes): Opens the Export Criteria dialog box (a thorough description of this dialog box can be found in the Import from Database chapter).

Database-Specific Contextual Menu Actions

In addition to the general contextual menu actions in the Data Source Explorer view, the various nodes in Oracle database connections include the following additional contextual menu actions:

XML Schema Repository Level Nodes

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

To avoid having to grant all these privileges to the schema owner, Oracle recommends that the registration be performed by a DBA if there are XML schema-based XMLType table or columns in other user database schemas.

XML Repository Level Nodes

Add container: Adds a new child container to the current one.
Add resource: Adds a new resource to the folder.

Container Level Nodes

Add container: Adds a new child container to the current one.
Add resource: Adds a new resource to the folder.
Delete: Deletes the current container.
Properties: Shows various properties of the current container.

Resource Level Nodes

Open: Opens the selected resource in the editor.
Rename: Renames the current resource
Move: Moves the current resource to a new container (also available through drag and drop).
Delete: Deletes the current container.
Copy location: Allows you to copy (to the clipboard) an application-specific URL for the resource that can then be used for various actions, such as opening or transforming the resources.
Properties: Shows various properties of the current container.
Compare: Compares two selected resources.

Was this helpful?