Previous Topic: Oracle Table Index Editor - Constraint State TabNext Topic: Oracle Library Editor - General Tab

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

Oracle Library Editor

Use the following options and tabs in the Oracle Library Editor to define Oracle library properties. You can open the Oracle Library Editor by selecting Target - Oracle, Library on the Model menu.

property editor PREVIOUS icon Previous

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

property editor NEXT icon Next

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

property editor SORT icon Sort

Sorts the libraries 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 library list is currently sorted:

property editor SORT icon

Specifies that the list is sorted in alphabetic order.

Property editor Reverse Alpha Sort Button

Specifies that the list is sorted in reverse alphabetic order.

New icon in property editors to create a new object New

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

property editor DELETE button Delete

Deletes the selected library.

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

Name

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

Owner

Lets you assign a database Owner to the library.

Use Replace Syntax

Lets you specify whether the library DDL that is generated during Forward Engineering to replace any occurrence of an identically-named library. If this check box is not selected, the library DDL generated will only attempt to create the object and will not attempt to replace it.

Generate

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

General

Lets you specify a database link for a library.

Comment

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

UDP

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

Notes

View library history information and view or edit user notes.

Libraries are supported in the following features: