Schema Adminstration dialog box (OSE)

Save Settings dialog box (OSE)

OSE Dialog Boxes

Select Feature Tables dialog box (OSE)

 

Schema Adminstration dialog box (OSE)

Use the Schema Administration dialog box to map features to layers and to manage indexes.

Oracle Service And Schema

Shows the connected service and schema.

Connect

Displays the Oracle Spatial Connection dialog box (OSE), where you can connect to an Oracle service and schema.

Feature Name And Properties

Use this grid to create and edit feature definitions.

Feature

Click the feature name cell to edit it. You can edit the definitions that have not yet been used to create an Oracle feature table. Feature definitions with existing, corresponding tables are grayed out and cannot be edited or deleted. To add a new feature definition, click the blank row at the bottom.

Table

Name of the table to be created in Oracle. You can change this name.

SRID

The coordinate system ID. To maintain coordinate system information, enter a valid coordinate system ID. For a list of valid IDs, refer to the Oracle MDSYS.CS_SRS table. For additional information on using and defining SRIDs, refer to your Oracle Spatial User Guide.

Layers

Enter the name of a layer or click [...] to see the list of available layers.

Set Attributes

Displays the Attribute Selection dialog box (OSE) where you can select attributes for inclusion in the currently selected feature.

Delete

Deletes the selected feature. To select a feature, click the left column.

Maintain Feature Definitions

Save Feature Metadata

Saves the feature definition information you have entered and creates metadata tables in the Oracle schema. Note that if you change a feature's name or delete a feature, these actions take place immediately and do not require that you click Save Feature Metadata.

Create Feature Tables

Takes the contents of the metadata tables and creates the Oracle tables and columns.

Locking

Controls the locking behavior for the current schema.

Enable Schema Locking

Select this option to turn on locking for the current schema. Clear it to disable locking.

Manage Locks

Displays the Lock Management dialog box (OSE) which lists the current locks, and allows you to delete them if you have the appropriate permissions.

Schema Management

Use this area to administer indexes and extents.

Drop Indexes

Displays the Select Features to Drop Indexes dialog box (OSE) where you can specify the features for which you want to delete indexes.

Create Indexes

Displays the Select Features to Create Indexes dialog box (OSE) where you can specify the features for which you want to create indexes.

Update Extents

Displays the Select Features dialog box (OSE) where you can specify the features that determine the extents of the area to be indexed.