Create DB Link To Another Oracle Database Using SQL

- Login to oracle using SQLDeveloper or TOAD

- Use below code to create DBLink , replace "apexhostingservices.com" & "connect to "TEST" identified by "1234"" with your own credentials and hostname

create database link "ANYNAME"
connect to "TEST" identified by "1234"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = apexhostingservices.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = XEPDB1)
)
)'
/