- Use below code to create DBLink , replace "oracleapexservices.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 = oracleapexservices.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = XEPDB1)
)
)'
/
