Database Links
Database links are pointers that define a one-way communication path from an Oracle Database server to another database server.
Creating a Database Link
To create a database link, you must have the CREATE SESSION privilege on the remote database. You must also have CREATE DATABASE LINK privilege to create a database link and CREATE PUBLIC DATABASE LINK to create a public database link.
- On the Standard toolbar, click New Database Object.
- Select the Database Link type in the dialog box.
- Input a database link name. If specified name is unique, the DbLink editor document will appear.
- Set connection details (service name and type of the link). For more information about database link types refer to Oracle documentation.
- Optionally, select Public or Shared check boxes to create public or shared database link. For shared database link specify user name and password to use when connecting to the remote database. On the text view the password can be seen unencrypted. Note that only DBA can see whether the database link is shared after creation.
- Save the document
To delete a database link, right-click a required link, and then click Delete on the shortcut menu.
Want to Find out More?
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?