oracle dblink 实验
来源:互联网 发布:c语言gui编程 编辑:程序博客网 时间:2024/06/05 02:59
在testdb1中创建dblink到testdb2
testdb1和testdb2都是11.2.0.3版本
1:在testdb1中配置TNS $ORACLE_HOME/db_1/network/admin 创建tnsnames.ora
内容如下:
testdb2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.23)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
(INSTANCE_NAME = orcl)
)
)
2:创建dblink
静态:
create public database link testdb2_link connect to system identified by redhat using 'testdb2';
动态:
create public database link testdb2_link connect to system identified by redhat using '
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.23)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
(INSTANCE_NAME = orcl)
)
)
';
create synonym testdb2user for all_users@testdb2_link;创建同义词;
select * from dba_synonyms where db_link is not null;
drop synonym testdb2user 删除同义词
3:查询
select *from all_users@testdb2_link
select * from testdb2user;
select owner,object_name from dba_objects where object_type='DATABASE LINK';
select owner, db_link from dba_db_links;
4:删除dblink
drop public database link TESTDB2_LINK;
5:impdp 通过dblink (long,lob类型的不支持,大对象类型不支持)
impdp system/redhat network_link=testdb1_link schemas=testuser;
- oracle dblink 实验
- Oracle DBLink
- Oracle dblink
- Oracle DBLink
- ORACLE DBLINK
- oracle dblink
- oracle dblink
- Oracle DBlink
- Oracle-DBLINK
- oracle dblink
- Oracle DBlink
- oracle dblink
- oracle,dblink
- oracle dblink
- oracle dblink
- oracle DBLink
- oracle dblink
- Oracle DBLINK
- strcpy,memset,memcpy三者之间的根本区别
- conversion to dalvik format failed with error 3
- IOS音频简单处理
- 07-jbpm工作流之根据流程变量分配任务Task
- hdu1878 欧拉回路
- oracle dblink 实验
- 在ubuntu13.04环境下配置apache的vhost
- Android LaunchMode SingleInstance 用法
- Pythpn格式化字符串
- 创建型模式(Creational Pattern) 简单工厂 simplefactory 单例 Singleton
- iOS 的 指针函数
- 两个单向链表,找出它们的第一个公共结点。
- eclipse编辑jsp没有代码提示
- android将一个String保存到.txt文本中