Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

snapshot too old: rollback segment number error when we run expdp command

926494May 9 2012 — edited May 11 2012

When we try to export the tables, we get a few error messages:

*************
ORA-31693: Table data object "XXuser"."XXTable1" 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 107 with name "_SYSSMU107_1363211066$" too small

ORA-31693: Table data object "XXuser"."XXTable2" 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 175 with name "_SYSSMU175_590907443$" too small
*************

Increased the size of undo tablespace to 280 GB and tried reexporting XXTabl1 but got the same error after 640GB of data.

Command Used for exporting the failed table: expdp user/pass tables=XXTable1 FILESIZE=100000m DIRECTORY=DATAPUMP DUMPFILE=datapump:exp_XX_Table.dmp,exp_XX_Table%U.dmp LOGFILE=naexp_table.log

Database: 11.2.0.1 installed on RHEL 5.6 x64
DB User: Custom user with dba privs and its own tablespace.

Edited by: 923491 on May 9, 2012 3:48 PM