大表exp/imp遷移

$ 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@]