Physical Modeling › Oracle Physical Property Editors › Oracle Table Editor

Oracle Table Editor

Use the Oracle Table Editor to specify the various properties for a table.

In the physical model, you can create the following types of tables:

• Independent table
• Dependent table

A table box has a horizontal line, which divides the box. You can enter the primary key above the line and non-keys below the line. You can choose to migrate keys to either the primary or non-key area of the box. Each table that you add graphically appears on the diagram window.

You can open the Oracle Table Editor in one of the following ways:

• Select Tables from the Model menu
• Right-click a table in the diagram, select Table Properties from the menu, and select a property that you want to modify
• Right-click a table in the Model Explorer and select Properties
• Single-click a table in the Model Explorer and click the Property Editor icon

The Oracle Table Editor dialog includes the following tabs:

General Edit the physical storage properties of the table. The available options for this tab vary depending on the Oracle version.

Table Options Enter options for a table such as sizing information, cache, row movement, and monitoring. The available options for this tab vary depending on the Oracle version.

Comment Add or edit comments for a table.

Partitions Specify physical partition values for a table. The available options for this tab vary depending on the Oracle version.

LOB Storage Assign LOB storage parameters for a table. The available options for this tab vary depending on the Oracle version.

Supplemental Logging Specify log groups and attach columns for logging. Options available vary between Oracle 9i and Oracle 10g.

Validation Specify validation rules and constraint state.

Synonym Create, edit, or delete synonyms that apply to the selected table.

Materialized View log Modify the properties for a materialized view log.

UDP Enter user-defined property values for the selected table.

History View the history for the selected table.

The following describes all of the other options available in this dialog:

Table

Displays the current table for which you can view properties.

Name

Enter or change the table name in this text box.

Owner

You can enter a name in this text box to assign a database Owner to the selected table.

Generate

Select this check box if you want to generate DDL for this object during Forward Engineering. If you do not select the check box, no DDL will be generated for this object during Forward Engineering.

Physical Only

Select this check box to include the table in the physical model only.

DB Sync

Starts the Complete Compare task so you can synchronize the physical objects defined in your model with the information stored on the server.