Oracle创建、删除DATABASE LINK



Oracle创建、删除DATABASE LINK

创建dblink：

?

1

2

3

4

5

6

7

8

9

10

11

create database link [name]

 connectto [username] IDENTIFIEDBY [password]

 using'(DESCRIPTION =

 (ADDRESS_LIST =

  (ADDRESS = (PROTOCOL = TCP)(HOST = [ip])(PORT = [port]))

 )

 (CONNECT_DATA =

  (SERVER = DEDICATED)

  (SERVICE_NAME = xxx)

 )

 )';

例如：

?

1

create public database link dblink_nameconnect toSYSTEM using '192.168.1.73:1521/oracle';




删除dblink：

?

1

2

3

DROP DATABASE LINK [name];

--或

DROP PUBLIC DATABASE LINK [name];