Accessing Data with Database Links

Previous

Next

---

Because the Database Home Page 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. On the Database Home Page, click the Object Browser icon.

   Object Browser appears.

2. Click Create.

3. Select Database Link and click Next.

4. 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. On the Database Home Page, click the Object Browser icon.

   Object Browser appears.

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