Previous Topic: Define Sybase Segments

Next Topic: Oracle Cluster Editor

Oracle Physical Property Editors

You use the Oracle physical property editors to work with the relational modeling features of Oracle. These editors are designed with common features that let you quickly create and maintain physical modeling objects.

These editors contain the following options:

Navigation Toolbar
property editor PREVIOUS icon Previous

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

property editor NEXT icon Next

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

property editor SORT iconSort

Sorts the objects by alphabetic or reverse alphabetic order in most instances; some objects support other ways to sort. If other ways of sorting objects exists it will be available using a drop-down selection method when you click the Sort button.

New icon in property editors to create a new object New

Creates an object that becomes the current object in the editor.

property editor DELETE button Delete

Deletes the selected object.

property editor DB SYNC buttonDB Sync

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

Note: This button is not available if the DB Sync function is not relevant to the current type of object in the editor.

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 objects in the Navigation Grid to quickly locate the object for which you need to view or define properties.

Navigation Grid

Provides a tabular representation of the current object and other objects of the same type. Properties relevant to the object display in separate cells, each with a text entry area, check box, or drop-down control for selecting available values. The amount of space allocated to the Navigation Grid can be adjusted by moving the splitter bar up and down. Columns within the Navigation Grid can be readjusted to be narrower or wider. Once you change a field, when you go to another field, the value is saved. If you click the Cancel button, it only cancels the change of the current field.

General Tab

Contains the main options for most Oracle objects and is where you define most of the necessary properties for that object. In certain editors, some of the options in this tab only become available after you have first selected a check box to enable that option.

Common Tabs

Provides additional functionality relevant to the editor. For example, all editors contain a Comment tab that lets you enter comments specific to that object.

Undo/Redo/Details

Provides icons you can click to undo the last action or redo the previous action within the editor. Click the Details button to open the Advisory Message Dialog that displays details about the action.

The following table summarizes the property editors that provide support for Oracle physical objects:

Object

Cluster

Column

Context

Database

Database Link

Directory

Disk Group

Function

Index Editor for Clusters

Index Editor for Materialized Views

Index Editor for Tables

Library

Materialized View Log

Materialized Views

Package

Package Body

Pre and Post Scripts

Rollback Segment

Sequence

Stored Procedure

Synonym

Table

Tablespace

Tablespace Group

Trigger

Views