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

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.