What are the ways to create a dblink

This article mainly introduces "what are the methods of creating dblink". In daily operation, I believe many people have doubts about what are the methods of creating dblink. Xiaobian consulted all kinds of materials and sorted out simple and easy operation methods. I hope to help you answer the doubts about "what are the methods of creating dblink"! Next, please follow the small series to learn together!

Combined with daily experience, there are several ways to create dblink:

(1)The most common method:

create database link dblink_120

connect to zhan identified by "zhan"

using '(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.50.120)(PORT = 1521)))

(CONNECT_DATA =(SERVICE_NAME = bond)))';

(2)Methods of using tns:

First we add tns on the server, note that this must be added under tnsname.ora on the server side of the target library, not under tnsname.ora on the client side, otherwise an error will be reported.

db_110 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = orcl)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

db_120 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.50.120)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = bond)

)

)

Then create dblink:

create database link dblink_120 connect to zhan identified by "zhan" using 'db_120';

(3)How to use host:port/sid:

create database link dblink_120 connect to zhan identified by "zhan" using '192.168.50.120:1521/bond';

Remove dblink method:

drop database link dblink_120;

At this point, the study of "what are the methods to create dblink" is over, hoping to solve everyone's doubts. Theory and practice can better match to help everyone learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!