Tag Archives: ORA-01555

ORA-31693: Table data object “SCOTT”.”HISTORY_DATA” failed to load/unload

ORA-31693: Table data object “SCOTT”.”HISTORY_DATA” failed to load/unload

Expdp is failing due to the following error. Taking backup of one of the big table.

ORA-31693: Table data object "SCOTT"."HISTORY_DATA" 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 74 with name "_SYSSMU74_1393023423$" too small

1. Check the UNDO RETENTION parameter for the ORA-01555 error.

Show parameter undo_retention

Note: Default value of undo_rention is 900. its value defined in seconds means 15 minutes.

2. Increase the value before the expdp session start.

Increase the undo retention time(in secs) with following command:

show parameter undo_rentention

3. Rollback the value as usually after EXPDP backup complete successfully.
Note: If error still occurred then you can also set its value more.

4. It’s fixed the issue in EXPDP backup.