Previous Topic: Oracle Physical Property EditorsNext Topic: Oracle Cluster Editor - General Tab

Creating Models › Target Servers for Physical Models › Database Property Editors › Oracle Physical Property Editors › Oracle Cluster Editor

Oracle Cluster Editor

Use the following options and tabs in the Oracle Cluster Editor to add or edit Oracle clusters and cluster properties.

property editor PREVIOUS icon Previous

Positions the editor on the previous cluster in the Navigation Grid.

property editor NEXT icon Next

Positions the editor on the next cluster in the Navigation Grid.

property editor SORT icon Sort

Sorts the clusters by alphabetic or reverse alphabetic order. You select the method you want using the drop-down menu that opens after you click the Sort button. Visual cues are provided for how the cluster list is currently sorted:

property editor SORT icon

Specifies that the cluster list is sorted in alphabetic order.

Property editor Reverse Alpha Sort Button

Specifies that the cluster list is sorted in reverse alphabetic order.

New icon in property editors to create a new object New

Creates a new cluster that becomes the current object in the editor.

property editor DELETE button Delete

Deletes the selected cluster.

property editor DB SYNC button DB Sync

Opens the DB Sync wizard so you can perform a database level compare of objects in the current model with matching objects in another model.

property editor HELP button Help

Opens online help for the editor.

enter filter text box in a property editor to filter object list

Lets you filter a very large list of clusters in the Navigation Grid to quickly locate the cluster for which you need to view or define properties.

Name

Specifies the name of the cluster. You can change the name of the cluster in this field.

Owner

Specifies the schema of the database to which the cluster belongs. You select the schema from the drop-down list.

Generate

Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

General

View and modify cluster properties such as cluster type and size.

Storage

Lets you specify values for cluster tablespace storage, transactions, and freelists.

Options

Lets you specify additional options for parallel type, row dependency, and cache type.

Index

Lets you create an Oracle cluster index.

Dependencies

Displays any dependencies for the cluster.

Comment

Lets you enter any comments that you want to associate with the cluster.

UDP

Lets you enter user-defined property values for a cluster.

Notes

Lets you view or edit user notes.

Oracle clusters are supported in the following features: