oracle对dblink和同义词的操作

创建dblink

create public database link dblinkName 
  connect to DH IDENTIFIED BY DH 
  using 
      '(DESCRIPTION =  
          (ADDRESS_LIST =
              (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
           )
          (CONNECT_DATA =
               (SERVICE_NAME = ORCL)
          )
         )';

删除dblink

drop public database link  dblinkName;

查看dblink

select * from dba_db_links;

创建同义词

create public synonym table_name for user.table_name;

删除同义词

drop public synonym table_name;

查看所有同义词

select * from dba_synonyms;