orcale中dblink的使用

create public database link to_orcl connect to postsale identified by postsale 
using ‘(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.229.197)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =orcl)
)
)‘;

select * from postsale.SHAREIMAGE@to_orcl ;

create or replace public synonym SHAREIMAGE  for postsale.SHAREIMAGE@to_orcl ;

select * from SHAREIMAGE