database link （分布式数据库）！

分布式数据库：

其实就是将一个大的数据库，按功能划分成多个小的数据库，每一个小的数据库功能、数据都相对独立，如果多个小数据库之间要互相访问数据，通过数据库链接。这就是分布式数据库，其实只是一个概念而已，生产中都用的非常普遍了！！！

创建数据库链接：

CREATE [ SHARED ] [ PUBLIC ] DATABASE LINK dblink
  [ CONNECT TO
    { CURRENT_USER
    | user IDENTIFIED BY password [ dblink_authentication ]
    }
  | dblink_authentication
  ]
    [ CONNECT TO
      { CURRENT_USER
      | user IDENTIFIED BY password [ dblink_authentication ]
      }
    | dblink_authentication
    ]...
  [ USING connect_string ] ;

例子：

-- Create public database link 
create public database link test_from_11 
  connect to scott identified by tiger
  using '192.168.40.11/ntpay';

-- Create database link 
create database link linktoacc
  connect to accuser identified by accuser
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.31.5)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.31.6)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = zfacc)
      (INSTANCE_NAME = zfacc1)
    )
  )';
  
-- 查看dblink
select * from user_db_links;