Browsing a Database Link

To browse a database link:

  1. On the Workspace home page, click SQL Workshop and then Object Browser.

    Object Browser appears.

  2. From the Object list, select Database Links.

  3. From the Object Selection pane, select a database link.

    The Object Details view appears.

Summary of Available Views

Click the tabs at the top of the page to view different reports about the database link. Table: Available Views for Database Links describes all available views.

Available Views for Database Links

View Description

Object Details

(Default) Displays details about the database link. Actions you can perform include:

  • Drop - Deletes the database link

  • Test - Tests the database link

Dependencies

Displays a list of objects that use (or depend) upon this database link.

SQL

Displays the SQL necessary to re-create this database link.