ORA-02354 ORA-01555

data/oracle/product/10.2.0.1/bin/expdp mma/mma schemas=mma  directory=dump_dir dumpfile=expdp_mma_`date +%F`_%U.dmp EXCLUDE=TABLE:\"IN\(\'MMA_LOG\'\)\"   parallel=2 filesize=8g logfile=expdp_mma.log

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "MMA"."SYS_EXPORT_SCHEMA_13":  mma/******** schemas=mma directory=dump_dir dumpfile=expdp_mma_2012-04-18_%U.dmp EXCLUDE=TAB
LE:"IN('MMA_LOG')" parallel=2 filesize=8g logfile=expdp_mma.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 19.64 GB
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE

。。。。。

. . exported "MMA"."MMA_FRANCHISE_APPLICATION"               0 KB       0 rows
. . exported "MMA"."MMA_TRIAL_BLACKLIST"                     0 KB       0 rows
. . exported "MMA"."PBCATCOL"                                0 KB       0 rows
. . exported "MMA"."PBCATTBL"                                0 KB       0 rows
. . exported "MMA"."PBCATVLD"                                0 KB       0 rows
ORA-31693: Table data object "MMA"."MMA_BLOG_DIARY" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 38 with name "_SYSSMU38$" too small
Master table "MMA"."SYS_EXPORT_SCHEMA_13" successfully loaded/unloaded
******************************************************************************
Dump file set for MMA.SYS_EXPORT_SCHEMA_13 is:
  /data/backup/expdp_mma_2012-04-18_01.dmp
  /data/backup/expdp_mma_2012-04-18_02.dmp
  /data/backup/expdp_mma_2012-04-18_03.dmp
Job "MMA"."SYS_EXPORT_SCHEMA_13" completed with 2 error(s) at 04:14:45

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7583803/viewspace-721512/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7583803/viewspace-721512/