1, exp direct=y recordlength=65535
IN direct mode, exp does comparable performance as expdp. Just the dump file larger round 15% .
2, imp commit=y recordlength=65535 buffer=10485760
imp does the essentially different way as impdp .
For imp, it always does a convertional import, Never direct load.
For impdp, it does the direct load.
So the test result is as expected: impdp is much faster than imp. 2 times faster or Evern great.
-- parameter of imp which about index
indexes=yes => imp execute index ddl , if the index is alread exists. Then skip it.
indexes=no =>imp does not execute index ddl .
skip_unusable_index=yes
If the index is alread exists and with unusable status, and if this parameter is not specified by imp . Then imp raise an error, the table data about the index will not be loaded. The default action about unusable index of imp is different with impdp . which(impdp) will load data , and stay index in orginal state or replace by DDL in dumpfile.
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/350519/viewspace-1042213/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- aix, linux 解决特殊符号文件名:
- 在AIX,LINUX系统中访问含特殊符号的文件
- SSH Host key verification failed
- 让一个普通用户看到另一个用户的包体
- dbms_scheduler package body INVALID 解决方案
- db_recovery_file_dest_size, v$flashback_database_logfile,v$restore_point引发的血案.
- impdp 遇到 ORA-07445 错误。重新EXPDP，IMPDP解决了。
- drop user 死锁（物化视图，JOB）
- expdp, impdp ORA-39213 Metadata processing not available
- aix login shell permission error trouble shooting.
