imp/exp/impdp/expdp
pb_watercuizhen
这个作者很懒,什么都没留下…
展开
-
ORACLE expdp/impdp
转载 :http://czmmiao.iteye.com/blog/2041703ORCALE10G提供了新的导入导出工具,数据泵。Oracle官方对此的形容是:Oracle DataPump technology enables Very High-Speed movement of data and metadata from one database to another....原创 2016-06-12 15:10:42 · 80 阅读 · 0 评论 -
oracle expdp impdp用法举例加介绍
转载 http://wcf1987.iteye.com/blog/804196Data Pump 反映了整个导出/导入过程的完全革新。不使用常见的 SQL 命令,而是应用专用 API(direct path api etc) 来以更快得多的速度加载和卸载数据。1.Data Pump 导出 expdp例子:sql>create directory dpdata1 as '/u0...原创 2016-06-30 17:32:23 · 124 阅读 · 0 评论 -
expdp/expdp用法介绍
select * from dba_directories; Grant read,write on Directory DATA_PUMP_DIR to dcsdb; expdp dcsdb/jdmssales@JDMS schemas=dcsdb directory=DATA_PUMP_DIR dumpfile =data.dmp logfile=expdp.log,job...原创 2016-06-30 17:33:48 · 124 阅读 · 0 评论