Accessing Data with Database Links

Because Oracle HTML DB runs on top of an Oracle database, you have access to all distributed Oracle database capabilities. Typically, you perform distributed database operations using database links.

A database link is a schema object in one database that enables you to access objects on another database. Once you have created the database link you can access the remote objects by appending @dblink to the table or view name where dblink is the Database Link Name you specify in the Create Database Object Wizard.

To create a database link:

1. Navigate to the Workspace home page.

2. Click the SQL Workshop icon.

3. Click Object Browser.

   Object Browser appears.

4. Click Create.

5. Select Database Link and click Next.

6. Follow the on-screen instructions.

   Note that Database Link names must conform to Oracle naming conventions and cannot contain spaces, or start with a number or underscore.

To view an existing a database link:

1. Navigate to the Workspace home page.

2. Click the SQL Workshop icon.

3. Click Object Browser.

   Object Browser appears.

4. Select the object type Database Links at the top of the page.