Previous
Previous
 
Next
Next

Creating a Database Link

To create a database link:

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

    Object Browser appears.

  2. Click Create.

  3. From the list of object types, select Database Link.

  4. Specify the following information and click Next.

    • Database Link Name

    • Connect To Schema

    • Password

    • Remote Hostname or IP

    • Remove Host Port

    • SID or Service Name

    A confirmation page appears.

  5. To view the SQL used to create the database link, click Show SQL.

  6. Click Create.