Oracle Maestro online help
Public database links
A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. A public database link is available to all users.
New public database links are created within Create Public Database Link Wizard. In order to run the wizard you should either
• | select the Object | Create Database Object... main menu item; |
• | select the Public Database Link icon in the Create Database Object dialog |
or
• | select the Public Database Link list or any object from that list in the explorer tree; |
• | select the Create New Public Database Link... item from the popup menu |
or
• | open the schema in Schema Editor and the Public Database Links tab there; |
• | press the Insert key or select the Create New Public Database Link item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar). |
To create a new public database link with the same properties as one of the existing public database link has:
• | select the Object | Duplicate Database Object... main menu item; |
• | follow the instructions of Duplicate Object Wizard. |
|
Public database links can be edited within Public Database Link Editor. In order to run the editor you should either
• | select the public database link for editing in the explorer tree (type the first letters of the public database link name for quick search); |
• | select the Edit Public Database Link ... item from the popup menu |
or
• | open the database in Database Editor and the Public Database Links tab there; |
• | select the Public Database Link to edit; |
• | press the Enter key or select the Edit Public Database Link item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar). |
You can change the name of the public database link using the Rename Public Database Link dialog. To open the dialog you should either
• | select the Public Database Link to rename in the explorer tree; |
• | select the Rename Public Database Link item from the popup menu |
or
• | open the database in Database Editor and the Public Database Links tab there; |
• | select the public database link to rename; |
• | select the Rename Public Database Link item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar). |
|
To drop a public database link:
• | select the public database link to drop in the explorer tree; |
• | select the Drop Public Database Link item from the popup menu |
or
• | open the schema in Schema Editor and the Public Database Links tab there; |
• | select the public database link to drop; |
• | press the Delete key or select the Drop Public Database Link item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar) |
and confirm dropping in the dialog window.
|