Physical Modeling › Oracle Physical Property Editors › Oracle Database Editor

Previous Topic: Define Oracle View Column Properties

Next Topic: Define General Options for an Oracle Database

Oracle Database Editor

Use the Oracle Database Editor to add and specify the parameters for a database. You can open the Oracle Database Editor by selecting Target - Oracle, Database on the Model menu.

Databases are supported in the following features:

This editor contains the following options:

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.

Name

Specifies the database name. You can change the name in this field.

Generate

Lets you specify 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.

The Oracle Database Editor also includes the following tabs:

General Lets you add and specify the parameters for a database.

Logging Lets you edit log groups and add log members.

Tablespace Lets you assign tablespaces to a database.

Comment Lets you add or edit comments for a database.

UDP Lets you enter user-defined property values for a database.

Notes Lets you view history information and view or edit user notes.

Note: There is no Dependencies tab since no object uses a database.