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:
On the Workspace home page, click SQL Workshop and then 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
Remote Host Port
SID or Service Name
A confirmation page appears.
Click Create.
To browse a database link:
On the Workspace home page, click SQL Workshop and then 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 1-11 describes all available views.
Table 1-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. |
To drop a database link in Object Browser:
On the Workspace home page, click SQL Workshop and then 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 Drop.
To confirm, click Finish.