3.12 Managing Database Links
A database link is a schema object in one database that enables you to access objects in another database. You can create, browse, drop a database link and view report.
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.
- Creating a Database Link
Create a database link using Object Browser. - Browsing a Database Link
Select a database link from the Object Selection pane and view different reports about the database link. - Reports for Database Links
Alternative views available when viewing a database links in Object Browser. - Dropping a Database Link
Select a database link from the Object Selection pane and click Drop.
Parent topic: Managing Database Objects with Object Browser
3.12.1 Creating a Database Link
Create a database link using Object Browser.
To create a database link:
Parent topic: Managing Database Links
3.12.2 Browsing a Database Link
Select a database link from the Object Selection pane and view different reports about the database link.
To browse a database link:
Parent topic: Managing Database Links
3.12.3 Reports for Database Links
Alternative views available when viewing a database links in Object Browser.
Table 3-11 describes all available reports for database links.
Table 3-11 Available Reports 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. |
Parent topic: Managing Database Links
3.12.4 Dropping a Database Link
Select a database link from the Object Selection pane and click Drop.
To drop a database link in Object Browser:
Parent topic: Managing Database Links