[20190520]exp imp on th fly.txt
[20190520]exp imp on th fly.txt
--//以前做的测试,查找浪费许多时间,做1个记录。
--//注:仅仅linux 操作系统,bash shell版本不能太低就可以实现,现在安装的linux bash shell应该都没有问题。
1.环境:
SCOTT@book> @ ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
2.测试exp:
exp on the fly, run:
create table t as select * from all_objects;
$ exp scott/book file=>(gzip>t.dmp.gz) tables=t buffer=8388608
Export: Release 11.2.0.4.0 - Production on Mon May 20 08:58:15 2019
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
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table T 83245 rows exported
Export terminated successfully without warnings.
$ file t.dmp.gz
t.dmp.gz: gzip compressed data, from Unix, last modified: Mon May 20 08:58:15 2019
SCOTT@book> rename t to ty;
Table renamed.
3.测试imp:
imp on the fly, run:
$ imp scott/book full=y file=<(gunzip <t.dmp.gz) buffer=8388608
Import: Release 11.2.0.4.0 - Production on Mon May 20 09:00:42 2019
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
Export file created by EXPORT:V11.02.00 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing SCOTT's objects into SCOTT
. importing SCOTT's objects into SCOTT
. . importing table "T" 83245 rows imported
Import terminated successfully without warnings.
imp scott/book full=y file=<(gunzip <t.dmp.gz) buffer=8388608
SCOTT@book> select count(*) from t union all select count(*) from ty;
COUNT(*)
----------
83245
83245
4.也可以通过管道实现所谓的不落地方式,只要建立将p.dmp.gz建立为管道文件:
$ mkfifo p.dmp.gz
$ ls -l p.dmp.gz
prw-r--r-- 1 oracle oinstall 0 2019-05-20 09:04:27 p.dmp.gz
--//再执行如下:
$ cat ad.sh
#! /bin.bash
exp scott/book file=>(gzip>p.dmp.gz) tables=t buffer=8388608 &
sleep 5
imp scott/btbtms@192.168.100.33:1521/test full=y file=<(gunzip <p.dmp.gz) buffer=8388608 &
wait
SCOTT@test> select count(*) from t ;
COUNT(*)
----------
83245
--//注expdp,impdp不支持这样方式,实际上expdp,impdp已经支持数据压缩(早期仅仅支持元数据),没有必要这样做,意义不大。
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· [.NET]调用本地 Deepseek 模型
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· .NET Core 托管堆内存泄露/CPU异常的常见思路
· PostgreSQL 和 SQL Server 在统计信息维护中的关键差异
· C++代码改造为UTF-8编码问题的总结
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 实操Deepseek接入个人知识库
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库