Oracle Database Links
A database link (dblink) links databases. It allows you to query against other databases using the syntax TABLENAME@DBLINK
.
Use the following code to create a database link:
create database link "database_link_name"
connect to username
identified by "password"
using 'connection_name';
The values you need to plugin are:
-
database_link_name
the name you want to give your database link and what you enter after the@
inTABLENAME@DBLINK
-
username
the username to connect to connect to the database -
password
the password for the username to connect to the database -
connect_name
the TNS or full domain name to uniquely identify the database connection
No Comments