create public database link DBLINK_WZGTAMS CONNECT TO  WZGTAMS identified by WZGTAMS

using '

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.112)(PORT = ))

    )

    (CONNECT_DATA =

      (SID = orcl11g)

      (SERVER = DEDICATED)

    )

  )';

select * from 用户名下的.表@建立的远程连接名字