Question

oracle中的database link如何使用

Answer 1

SQL> CREATE DATABASE LINK mydblink
2 CONNECT TO test IDENTIFIED BY test123
3 USING '(DESCRIPTION =
4 (ADDRESS_LIST =
5 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.210)(PORT = 1521)))
6 (CONNECT_DATA = (SERVICE_NAME = orcl)
7 )
8 )';

Database link created.

SQL> select count(1) from user_tables@mydblink;

COUNT(1)
----------
6

注：
如果创建全局dblink，必须使用systm或sys用户，在database前加public。