通过dblink impdp导入
来源:互联网 发布:fit健身软件好用吗 编辑:程序博客网 时间:2024/05/16 00:46
实验:
源数据库:10.5.129.160 dwhtest
需要导入的数据库:10.5.129.130 dwhtest
在10.5.129.130上创建DBLINK
SQL> create public database link DBL_DWHTEST connect to dwf identified by dwf using 'dwhtest160';
Database link created.
SQL> select * from dual@DBL_DWHTEST;
D
-
X
在10.5.129.130上执行impdp
[oracle@dwhtest admin]$ impdp dwf/dwf NETWORK_LINK=DBL_DWHTEST schemas=dwf
Import: Release 11.2.0.4.0 - Production on Wed Dec 18 10:15:23 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "DWF"."SYS_IMPORT_SCHEMA_01": dwf/******** NETWORK_LINK=DBL_DWHTEST schemas=dwf
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 260.9 GB
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"DWF" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
- 通过dblink impdp导入
- example:利用impdp通过dblink导入数据库
- example:利用impdp通过dblink导入数据库
- impdp+network_link(dblink)导入数据
- bug 4511371:10G和11G之间expdp/impdp通过dblink导入导出
- oracle dblink impdp network_link
- impdp导入
- oracle impdp通过network_link不落地方式导入数据
- oracle通过impdp导入数据时报ora-39064错误
- Oracle impdp通过network_link不落地方式导入数据
- impdp 导入报错
- impdp导入时卡死
- impdp数据表table导入
- impdp导入时卡死
- ORACLE impdp 导入数据
- impdp导入到数据库
- impdp使用network_link导入
- impdp导入dmp文件
- Hadoop权限管理
- OpenCart之商品分类(Category)模块教程
- 简单的生产者消费者模型
- boost::bind\boost::function
- Android的SoundPool
- 通过dblink impdp导入
- Solr3.6.1 在Tomcat6下的环境搭建
- Struts2入门的第一个应用
- [枚举]糖果采购
- 软件测试面试题整理
- RHEL6 DNS服务详解
- 改变按钮获取焦点、点击、失去焦点是的背景
- EditText将光标挪动到文字的结尾
- Partitioner