Create DB Link To Another Oracle Database Using SQL

- Login to oracle using SQLDeveloper or TOAD

- 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)
)
)'
/

  • dblink, oracle
  • 6 Users Found This Useful
Was this answer helpful?

Related Articles

How To Download Schema Backups

- This article is divided into two types of hosting accounts namely , Shared Hosting Database...

Connect to Database with SQL Developer

The Email you receive when you place an order contains Host name, port, database name, user and...

Connect To Database WIth Toad

The Email you receive when you place an order contains Host name, port, database name, user and...