Oracle创建Database link

create database link rickdb connect to scott identified by yuyang using '(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.141.85)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )';

CREATE TABLE RICK AS SELECT * FROM EMP@RICKDB;

 

posted @ 2012-11-23 08:58  niuniuwangyue  阅读(86)  评论(0编辑  收藏  举报