Access data remotely by creating a database link.
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
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.
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.
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.
Parent topic: Accessing Data with Database Links
To create a database link:
Parent topic: Accessing Data with Database Links
To view an existing a database link:
Parent topic: Accessing Data with Database Links