$ 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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/271283/viewspace-1011874/ ，如需转载，请注明出处，否则将追究法律责任。
