#確認從local database到remote database的網絡連接是正常的，tnsping要能成功。
#確認在remote database上面有相應的訪問權限。

create public database link 

create database link 

grant create public database link, create database link to myAccount;

set linesize 300
set pagesize 999
col DB_LINK format a30
col USERNAME format a30
col HOST format a30
col CREATED format a10
col OWNER format a10
col object_name format a20
select owner,object_name from dba_objects where object_type='DATABASE LINK';
SELECT	 A.OWNER, A.HOST, A.DB_LINK, A.USERNAME, A.CREATED,
		 DECODE (B.FLAG, 0, 'NO', 1, 'YES') "DEC", B.AUTHUSR, C.STATUS
	FROM DBA_DB_LINKS A, SYS.USER$ U, SYS.LINK$ B, DBA_OBJECTS C
   WHERE A.DB_LINK = B.NAME AND
         A.OWNER   = U.NAME AND
         B.OWNER#  = U.USER# AND
         A.DB_LINK = C.OBJECT_NAME AND
         A.OWNER   = C.OWNER AND
         C.OBJECT_TYPE = 'DATABASE LINK'
ORDER BY 1, 2, 3;
查看dblink的link信息：
select * from dba_db_links;

select * from dba_db_links;

create database link LIS_LINK01 connect to bUser identified by bPasword using '10.22.xx.xx:1521/orcl'
create database link hebtz connect to hebtz identified by "1" using '192.168.2xx:1521/hebtzstd';

create database  link blink1 connect to dbName identified by dbPassword using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.1.106)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))';
--blink1 ： 表示dblink名字
--dbName ：表示 遠程數據庫的用戶
--dbPassword：表示 遠程數據庫的密碼
--HOST ： 表示遠程數據庫IP
--PORT ： 表示遠程數據庫端口
--SERVICE_NAME ： 遠程數據庫的實例名

select * from T_WEBSERVICE@db3

DROP PUBLIC database link link_name;

DROP database link link_name;

create table test as select * from T_WEBSERVICE@db3