Current location:

Oracle Spatial

Location: Overlay Types dialog > Databases > Oracle Spatial

The Oracle Connection dialog will be displayed:

User

The Oracle user name.

Password

The password for an Oracle username.

Server

The Oracle server to use. This name is sometimes referred to as the 'Net Service Name' or 'Host String'.

Save connection details in Options database (with encrypted password)

Check this tickbox if SIS should store these connection details in the Options database. The password will be stored in encrypted form for security.

Saved connection name

This text box will become active if the Save connection details in Options database (with encrypted password) tickbox is checked. Enter a meaningful name for this connection. This text box cannot be left blank and the same name cannot be used twice.

If the Oracle connection has been made previously, and the connection details saved, the Oracle Connection dialog will be displayed in the form shown below:

In this case click one of the Saved connections to complete the connection details.

If there are any connections currently in use these will be shown as follows:

in this case one of these currently used connections can be selected to complete the connection details.

Click Next.

The Database connection type dialog will be displayed:

Select from:

Simple

Opens one or more spatial database tables, with default configuration options.

Advanced

Opens a single spatial database table, with advanced configuration options.

Create

Creates a new, empty spatial database table.

Advanced

Highlight the Oracle Spatial Layer you wish to open as a SIS overlay.

Click Next.

The Oracle Spatial/Locator Connection dialog will be displayed to allow you to configure how the overlay should be opened and presented in SIS:

Connection Type

Dynamic (default)

This option maintains an active connection to the Oracle database, with all redraws returning to the server.

The dataset will be editable, subject to Oracle user privileges.

Note: Dynamic connection requires spatial index on the table and column.

Local cache

Makes a local copy of the entire table. The dataset will be read-only.

If this option is chosen the following warning will be displayed when you click Finish:

This is to inform you that the entire table will be loaded into local, file-based, temporary storage. The connection to the database will be remembered and the local storage will be recreated when the SWD is opened.

Check the Don't ask again tickbox if you do not want to see this warning again during this session.

One-off import

Copies the entire table into an Internal Overlay.

If this option is chosen the following warning will be displayed when you click Finish:

This is to inform you that the entire table will be loaded into an Internal Overlay. The connection to the database will be not be remembered.

Check the Don't ask again tickbox if you do not want to see this warning again during this session.

Note: Cadcorp SIS 8.0 does not remember the Connection Type settings between uses of a database connection and will always default to Dynamic.

Only load data overlapping the current map view extents

This option is available for Local cache and One-off import connection types only.

ID Column

This parameter is for future use.

Optional Feature Coding

Feature Code Column

The Field that will be used to set the Feature Code on Items in the Dataset.

Feature Table

The Feature Table to use for feature-coded Items in this Dataset. Feature-coded Items get information about their Feature Code from this Feature Table.

If you intend to use a Feature Table with your overlay, you must ensure that the Oracle table contains the appropriate feature code attribute as well as the geometry type containing the spatial data. If your data was loaded using the Cadcorp OS MasterMap Manager, the feature code is exported for you.

If you created your dataset using the export utility in Cadcorp SIS 8.0, you must ensure that the feature code column is listed in the overlay schema before exporting the overlay.

Alternatively if there is no feature code attribute, you can generate one manually using one of the Oracle database interfaces such as SQL Plus.

To apply a feature table select the feature code attribute from the Feature Code Column drop-down list. The feature code attribute must be in the Oracle table in a column of a number type. Select the appropriate feature table from the Feature Table drop-down list.

Overlay Configuration

Name

This is the full name of the selected overlay which can be edited.

Theme

This drop-down shows any Themes associated with the overlay:

Choose the required theme from the drop-down.

If you do not want to modify the dataset's Coordinate Reference System, scale, etc. click Finish.

If you do want to make changes click the More Properties... button.

The AOracleSpatialCursorDts dialog will be displayed:

Coordinates:

Displays the coordinate reference system that the dataset items are defined in.

Scale:

The default viewing scale for this dataset. This will affect how text items convert their point heights into world sizes.

Click the Properties... button to display the resizeable Oracle Spatial dialog:

Click Close in the Oracle Spatial dialog (above), click OK in the AOracleSpatialCursorDts dialog, control is now returned to the PostGIS Connection dialog.

Click Finish in the PostGIS Connection dialog.

Create

Table Name

The name of the Oracle spatial layer. You can enter any Oracle compliant table name.

Geometry Column Name

The name for the column in the Oracle table is GEOMETRY, and is type geometry. The name of the column can be changed.

Feature ID column

The name of the Feature ID column.

Coordinate Reference System

The Coordinate Reference System associated with the spatial layer defaults to the Coordinate Reference System for the overlay.

Advanced configuration

Geometry Dimension

Select the 2D or 3D radio button.

Default Schema Columns

Use the drop-down to select the required default schema column:

Overlay Configuration

Name

This is the full name of the selected overlay which can be edited.

Theme

This drop-down shows any Themes associated with the overlay:

Choose the required theme from the drop-down.

Click Next.

The Cursor Dataset Details dialog will be displayed:

Transactions

Click on Begin to start a transaction. Click Finish. Begin editing the data.

After the edits are finished redisplay the Cursor Dataset Details dialog and you will two active options:

Rollback

This will release the transaction and allow other users to obtain editable access to the data. The changes you made will not be applied to the dataset.

Note: Regenerating an overlay whilst in the middle of a transaction causes the transaction to rollback. In addition all undo information for the overlay will be cleared.

Commit

This will commit the changes permanently to the database and release the transaction. All users will now be able to view the data.

Alternatively, the three Transaction commands; Begin, Commit and Rollback may also be accessed locally as shown below:

Only allow editing inside a Transaction

Check this tickbox to ensure no edits can be made outside of the current transaction.

Top of page

Send comments on this topic.

Click to return to www.cadcorp.com