18.7 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 Application Express SQL Workshop Guide
-
"Database Links" in Oracle Database Administrator’s Guide
Parent topic: Managing Application Data
18.7.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 Database Administrator’s Guide.
Because Oracle Application Express runs in the Oracle database, you have access to all distributed Oracle 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.7.2 Creating a Database Link
Create a database link in Object Browser.
To create a database link:
Parent topic: Accessing Data with Database Links
18.7.3 Viewing an Existing Database Link
View existing database links in Object Browser.
To view an existing a database link:
Parent topic: Accessing Data with Database Links