请问 EXP 时的 ORA-01555 错误
最近我在用 EXP 来备份资料库时就常常出了这样的错误:Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
Export done in UTF8 character set and UTF8 NCHAR character set
. about to export COST's tables via Direct Path ...
. . exporting table LSOUTWK_TMP 53477 rows exported
. . exporting table LSOFFADJD 0 rows exported
. . exporting table NSHINVDD 0 rows exported
. . exporting table MATINVD 20900 rows exported
. . exporting table MATM_C_TMP 6040 rows exported
. . exporting table LSOUTDD_TMP 1127660 rows exported
. . exporting table FACT_COMP 11 rows exported
. . exporting table VMATID 0 rows exported
. . exporting table LSINDD_TMP 554868 rows exported
. . exporting table KY_FILES 0 rows exported
. . exporting table COSTMATM 628211 rows exported
. . exporting table HISDD 0 rows exported
. . exporting table LSDETAILWK_TMP 23151 rows exported
. . exporting table VOUMATOD 245543 rows exported
. . exporting table FSTOCKD 9492 rows exported
. . exporting table TSALED 22934 rows exported
. . exporting table FEESTOCKD 0 rows exported
. . exporting table LSDETAILD 0 rows exported
. . exporting table YMLOCKD 384 rows exported
. . exporting table CSTPLAND 1831862 rows exported
. . exporting table LSSUMD 0 rows exported
. . exporting table TADJD 353 rows exported
. . exporting table LSOFFIND_TMP 392548 rows exported
. . exporting table ODRSALED 46289 rows exported
. . exporting table PRODUCTD 61502 rows exported
. . exporting table TRETD 1 rows exported
. . exporting table LSOVER_TMP 84169 rows exported
. . exporting table PROCD 207361 rows exported
. . exporting table STOCKD 889045 rows exported
. . exporting table VSTOCKD 0 rows exported
. . exporting table FEEMATOD 0 rows exported
. . exporting table WIPSALED 0 rows exported
. . exporting table LSDETAILD_TMP 110610 rows exported
. . exporting table LSOFFOVER_TMP 88884 rows exported
. . exporting table FEEMRODUCTD 0 rows exported
. . exporting table LSIND 0 rows exported
. . exporting table LSOUTWKD_TMP 156 rows exported
. . exporting table LSINWKD_TMP 156 rows exported
. . exporting table FEETPMATD 0 rows exported
. . exporting table HDUDINVD 0 rows exported
. . exporting table MATM_C 0 rows exported
. . exporting table OSTOCKD 0 rows exported
. . exporting table LSLOCKD_TMP 0 rows exported
. . exporting table SHPINVDD 0 rows exported
. . exporting table PBCATFMT 0 rows exported
. . exporting table TMP_UCOMPD
. . exporting table TMP_SALE
. . exporting table TALLADJD 29355 rows exported
. . exporting table LSOUTWKD 0 rows exported
. . exporting table MATACCN 93 rows exported
. . exporting table TMP_MATM
. . exporting table CLASSED 0 rows exported
. . exporting table SHPINVD 0 rows exported
. . exporting table NSHINVD 0 rows exported
. . exporting table MADJD 237 rows exported
. . exporting table T3MATD 0 rows exported
. . exporting table LSOFFIND 0 rows exported
. . exporting table HISPRESD 0 rows exported
. . exporting table LSADJD_TMP 0 rows exported
. . exporting table LSINWKD 0 rows exported
. . exporting table EXPD 33072 rows exported
. . exporting table TPMATD 913987 rows exported
. . exporting table MRODUCTD 64758 rows exported
. . exporting table INVTOD 0 rows exported
. . exporting table LSCONVERT 0 rows exported
. . exporting table LSOUTDD 0 rows exported
. . exporting table LSIND_TMP 387120 rows exported
. . exporting table LSOFFOVER 0 rows exported
. . exporting table MSALED 22824 rows exported
. . exporting table MALLADJD 30724 rows exported
. . exporting table PBCATEDT 0 rows exported
. . exporting table PROCESSD 105236 rows exported
. . exporting table TAB_ID 3390866 rows exported
. . exporting table FEEMPMATD 0 rows exported
. . exporting table FEEPROCESSD 0 rows exported
. . exporting table TMP_ERROR
. . exporting table PBCATVLD 0 rows exported
. . exporting table LSADJD 0 rows exported
. . exporting table LOTODRD 30736 rows exported
. . exporting table EXPM 71 rows exported
. . exporting table CSTFACTM 11 rows exported
. . exporting table LSINWK 0 rows exported
. . exporting table PBCATTBL 88 rows exported
. . exporting table FEEPRODUCTD 0 rows exported
EXP-00008: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number 6 with name "RBS5" too small
EXP-00000: Export terminated unsuccessfully
我的 rollback segment 是这样的 : 共有 25 个，从 RBS0 --> RBS24 ，使用的 tablespace : RBS 共有 3 个 datafile ，每datafile 是 2 GB，
每一个 rollback segment 是 :
inital extent : 5 M
next extent : 10 M
optimal size : 100 M
min extents : 15
max extents : 500
请各位帮忙看一下是为什麽会出这样的错误
先谢谢囉!!!!:rose: :rose: :rose:
页:
[1]