Because the Workspace home page runs in 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.
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 needs to grant this specific privilege to the database user in the user's workspace. See "Creating Database Links" in Oracle Database Administrator's GuideTo create a database link:
On the Workspace home page, click SQL Workshop and then Object Browser.
Object Browser appears.
Click Create.
Select Database Link and click Next.
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:
On the Workspace home page, click SQL Workshop and then Object Browser.
Object Browser appears.
Select the object type Database Links at the top of the page.
See Also:
"Managing Database Objects with Object Browser" in Oracle Application Express SQL Workshop and Utilities Guide and "Database Links" in Oracle Database Administrator's Guide