ORA-31693: Table data object “SCOTT”.”HISTORY_DATA” failed to load/unload
Error
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
Solution
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
ALTER SYSTEM SET UNDO_RETENTION = 2400;
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.