|
Oracle® HTML DB
Release 2.0 |
|
 Previous |
 Next |
A database link is a schema object in one database that enables you to access objects in another database. 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 name of the database link.
Topics:
To create a database link:
Navigate to Object Browser:
Click the SQL Workshop icon on the Workspace home page.
Click Object Browser.
Object Browser appears.
Click Create.
From the list of object types, select Database Link.
Specify the following information and click Next.
Database Link Name
Connect To Schema
Password
Remote Hostname or IP
Remove Host Port
SID or Service Name
A confirmation page appears.
To view the SQL used to create the database link, click Show SQL.
Click Create.
To browse a database link:
Navigate to Object Browser:
Click the SQL Workshop icon on the Workspace home page.
Click Object Browser.
Object Browser appears.
From the Object list, select Database Links.
From the Object Selection pane, select a database link.
The Object Details View appears.
Click the tabs at the top of the page to view different reports about the database link. Table 18-11 describes all available views.
Table 18-11 Available Views for Database Links
| View | Description |
|---|---|
|
Object Details |
(Default) Displays details about the database link. Actions you can perform include:
|
|
Dependencies |
Displays a list of objects that use (or depend) upon this database link. |
|
SQL |
Displays the SQL necessary to re-create this database link. |