ITPub博客

首页 > 数据库 > Oracle > 大表exp/imp迁移

大表exp/imp迁移

原创 Oracle 作者:jolly10 时间:2008-10-14 12:17:50 0 删除 编辑

$ exp mtrx/mtrx tables=BRAND_SPENDING_MM_MP file=mtrx.dmp log=mtrx.log statistics=none buffer=4096000 direct=y recordlength=65535

Export: Release 10.2.0.4.0 - Production on Mon Oct 13 22:40:23 2008

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


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

About to export specified tables via Direct Path ...
. . exporting table BRAND_SPENDING_MM_MP 31651968 rows exported
Export terminated successfully without warnings.


$ ls -lh mtrx.dmp
-rw-r--r-- 1 oracle dba 1.5G Oct 13 22:44 mtrx.dmp

运行了5分钟,如果什么参数都不加的话,时间是现在的几倍.

这个链接exp/imp迁移大表的事项.
http://www.itpub.net/viewthread.php?tid=903208&extra=&highlight=exp&page=1

[@more@]

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

请登录后发表评论 登录
全部评论

注册时间:2008-02-20

  • 博文量
    263
  • 访问量
    769047