EXP 時候 ORA-01555 解決方法:
1. 使用 consistent=n
2. 更改參數 : ALTER SYSTEM SET UNDO_RETENTION = 30000;
3. 加大UNDO表空間 .
4. 儘量在系統不繁忙的時候exp .
exp "'sys/oracle as sysdba'" buffer=8192 owner=pdmext feedback=100 consistent=n compress=n filesize=10G log=pdmext
exp "'sys/oracle as sysdba'" buffer=8192 owner=pdmext rows=n file=pdmext consistent=n compress=n log=pdmext
exp "'sys/oracle as sysdba'" buffer=8192 owner=pdmext feedback=100 consistent=n
compress=n filesize=20G log=pdmext_data file=(pdmext_1,pdmext_2,pdmext_3,pdmext_4,pdmext_5)
imp "'sys/oracle as sysdba'" fromuser=pdmext touser=pdmext file=pdmext.dmp log=pdmextimp ignore=y
imp "'sys/oracle as sysdba'" fromuser=pdmext touser=pdmext file=pdmext_1.DMP log=pdmextimp_data ignore=y
子查询：
exp system/system QUERY="WHERE streamid>=1 and streamid<2000" buffer=8192 tables=pdm626.streamdata feedback=50 consistent=n compress=n filesize=20G log=pdm_streamdata file=(pdmstream_1,pdmstream_2)
http://www.itpub.net/showthread.php?threadid=737672&pagenumber=
把归档关了;观察读写速度，看是否没有把存储的写缓存打开;
临时表空间加大;
导入数据前别事先创建索引;
加大logfile到2G 或更大
設置一个大一点的buffer，加上commit=y
還有一些注意點: 參考 http://www.itpub.net/showthread.php?threadid=521294&pagenumber=
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-84523/，如需转载，请注明出处，否则将追究法律责任。
