创建公共dblink只
create public database link test_link
connect 用csservicedb identified by huawei123
using ”(DESCRIPTION =才能
,,(ADDRESS_LIST =,,,,,(ADDRESS =, (=PROTOCOL TCP) (=HOST 192.168.0.119) (PORT =, 1521))
,,,)
,,(CONNECT_DATA =,,,,,(=SERVICE_NAME orcl)
,,,)
,,);
Database 才能;link 创建。
完成,desc cs_user;
错误:
ora - 04043: object cs_user does not 存在
完成,desc cs_user@test_link;
,名字,,空?,,,,的类型
,- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -女人,- - - - - - - - - -,- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
pk_bur_userid大敌;,,NOT NULL VARCHAR2 (18)
bur_user_flag大敌;,,NOT NULL VARCHAR2 (32) select *,得到dba_objects where object_type=癉ATABASE 链接”;
select 所有者,db_link 得到dba_db_links;,,,,查看dblink的所有者及链接名字
删除dblink只
完成,DROP PUBLIC DATABASE LINK csmain;
Database link 下降。
完成,DROP PUBLIC DATABASE LINK csserver;
Database link 下降。
完成 如果语句中不加,则创建的所有者就是现连接的用户只
完成,create , database link CSMAIN
connect 用csmaindb identified by huawei123
using ”(DESCRIPTION =才能
,,(ADDRESS_LIST =,,,,,(ADDRESS =, (=PROTOCOL TCP) (=HOST 192.168.0.119) (PORT =, 1521))
,,,)
,,(CONNECT_DATA =,,,,,(=SERVICE_NAME orcl)
,,,)
)的才能,;
老板,完成,select db_link 得到dba_db_links;
OWNER ,,,,, DB_LINK
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -,- - - - - - - - - - - - - - - - - -
CS_AUX ,,,,, CSMAIN
CS_AUX ,,,,,, CSSERVER
