Previous Next JavaScript must be enabled to correctly display this content

## 18.10 Accessing Data with Database Links

Access data remotely by creating a database link.

- About Database Links
  A database link is a schema object in one database that enables you to access objects on another database.
- Creating a Database Link
  Create a database link in Object Browser.
- Viewing an Existing Database Link
  View existing database links in Object Browser.

See Also:

- Managing Database Objects with Object Browser in Oracle APEX SQL Workshop Guide
- Database Links in Oracle AI Database Administrator’s Guide

Parent topic: Managing Application Data

### 18.10.1 About Database Links

A database link is a schema object in one database that enables you to access objects on another database.

Note:

By default, the CREATE DATABASE LINK system privilege is not granted to a provisioned workspace or database user. To use this feature, a DBA or administrator must grant this specific privilege to the database user in the user's workspace. See Creating Database Links in Oracle AI Database Administrator’s Guide.

Because Oracle APEX runs in the Oracle Database, you have access to all distributed database capabilities. Typically, you perform distributed database operations using database links.

Once you create a 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.

Parent topic: Accessing Data with Database Links

### 18.10.2 Creating a Database Link

Create a database link in Object Browser.

To create a database link:

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

   Object Browser home page 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.

Parent topic: Accessing Data with Database Links

### 18.10.3 Viewing an Existing Database Link

View existing database links in Object Browser.

To view an existing a database link:

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

   Object Browser appears.

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

Parent topic: Accessing Data with Database Links