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:

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.