Home > SQL Developer Dialog Boxes ... > Create/Edit Database Link
The following information applies to a database link, which is a database object in one database that enables you to access objects on another database, as explained in Database Links (Public and Private).
Public: If this option is checked, the database link is public (available to all users). If this option is not checked, the database link is private and is available only to you.
Schema: Database schema in which to create the database link.
Name: Name of the database link. Must be unique within a schema.
Host Name: The service name of a remote database. If you specify only the database name, Oracle Database implicitly appends the database domain to the connect string to create a complete service name. Therefore, if the database domain of the remote database is different from that of the current database, you must specify the complete service name.
Current User: Creates a current user database link. The current user must be a global user with a valid account on the remote database. If the database link is used directly, that is, not from within a stored object, then the current user is the same as the connected user.
Fixed User: Creates a fixed user database link, for which you specify the user name and password used to connect to the remote database.
Shared: If this option is checked, a single network connection is used to create a public database link that can be shared among multiple users. In this case, you must also specify the Authentication information.
Authentication - User Name and Password: The user name and password on the target instance. This information authenticates the user to the remote server and is required for security. The specified user and password must be a valid user and password on the remote instance.
DDL tab
You can review and save the SQL statement that SQL Developer will use to create the database link.
Related Topics