创建dblink的方法

create database link test
  connect to pgis identified by pgis
  using '(DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST =10.122.135.86)(PORT =1521))
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.135.86)(PORT =1521))
    (LOAD_BALANCE = yes)
     (CONNECT_DATA =
     (SERVICE_NAME = ceshi)
     (SERVICE_NAME = ceshi)
    )
   )';

create table ab_fkjlfp as select * from pgis.ab_fkjlfp@YSHAB将远程的数据库表复制到本地