Physical Modeling › Oracle Physical Property Editors › Oracle Database Link Editor

Oracle Database Link Editor

Use the Oracle Database Link Editor to create or edit properties for an Oracle database link.

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

• Select Database Link from the Database menu (Oracle 9i and 10g only)
• Right-click an Oracle database link in the Model Explorer and select Properties
• Single-click an Oracle database link in the Model Explorer and click the Property Editor icon

For Oracle 9i and 10g, database links are supported in the following features:

• Forward Engineering
• Reverse Engineering

The Oracle Database Link Editor dialog includes the following tabs:

General Assign the connection type to a database link.

Comment Add or edit comments for a database link.

UDP Enter a user-defined property value for a selected database link.

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

• Database Link

  A list box that contains all the available database link objects in the current model.

• New

  Select New to create a new database link. Opens the Create Database Link dialog where you can specify the name for the new database link.

• Rename

  Select Rename to rename a database link that you select from the Database Link list box.

• Delete

  Select a database link from the Database Link list box that you want to delete, and click the Delete button.

• 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.

• 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.