Query to create DB_Link from one database to another database.

How to create DB Link.

First delete the DB Link if it is already there.

sql:>/ drop database link “Database_link_name”

To create the Database link.

create  database link “DBLINK_NAME”
connect to “User_Name”
identified by “Passwrod”
using ‘(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = “Host_name or IP Address”)
(Port = “DB_Port”)))
(CONNECT_DATA = (SID = “DB_SID”))
)’;