10g新特性之-expdp与传统exp的速度比较

测试环境：
win2k
P4 2.93GHz
512M
数据量:
单表测试,70916行记录，11.2 MB左右数据



1.使用 expdp

花费时间:
Tue 30 May, 2006 9:46:12 - Tue 30 May, 2006 9:46:53 = 7秒

C:> expdp bm/bm123 dumpfile=bmt_mat.dmp directory=my_dir tables=bmt_mat job_nam
e=exptabdate

Export: Release 10.2.0.1.0 - Production on Tuesday, 30 May, 2006 9:46:12

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Starting "BM"."EXPTABDATE": bm/******** dumpfile=bmt_mat.dmp directory=my_dir t
ables=bmt_mat job_name=exptabdate
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 13 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "BM"."BMT_MAT" 10.63 MB 70916 rows
Master table "BM"."EXPTABDATE" successfully loaded/unloaded
******************************************************************************
Dump file set for BM.EXPTABDATE is:
F:DATABAKBMT_MAT.DMP
Job "BM"."EXPTABDATE" successfully completed at 09:46:53


2.使用 exp

花费时间:
Tue 30 May, 2006 10:01:36 2006 - Tue 30 May, 2006 10:01:47 2006 = 11秒

C:> exp bm/bm123 buffer=2048000 grants=y compress=N file=F:bmt_mat.dmp tabl
es=bmt_mat

Export: Release 10.2.0.1.0 - Production on Tue May 30 10:01:36 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table BMT_MAT 70916 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
当前时间: 10:01:47 2006

in oracle 10g，新增了expdp和impdp的功能，oracle建议采用expdp/impdp来取代exp/imp，要使用exp/imp，首先要建立 directory对象，然后才能进行exp/imp操作，expdp/impdp提供很多新的功能，例如：

1.可以对exp操作进行评估：exp userid=system/manager directory=test schemas='scott' estimate_only=y

2.可以定义include和exclude对象类型

3.支持version

4.支持network link

5.支持job操作，可以通过dbms_datapump.start_job重新启动job

6.支持长事务的attach和detach操作

Refer:http://www.eygle.com/10g/10g_expdp&impdp_speed.htm

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/77580/viewspace-212762/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/77580/viewspace-212762/