ORA-31693 ORA-01555 Error

The following error message is displayed when you export data from the Oracle10g Data Pump:

ORA-31693: Table Data Object "smartgps2006". "mcc_asyn_pos": "mcc_asyn_pos201409" failed to load/unload and is being skipped due to error:
ORA-29913: Error in executing odciexttablepopulate callout
ORA-01555: Snapshot too old: rollback segment number 21 with name "_ syssmu21 $" too small

The solution is as follows:

Show parameter undo_retention; view the value of this variable

SQL> show parameter undo_retention;

Name type value
-----------------------------------------------------------------------------
Undo_retention integer 900

Modify the value of this parameter:

Alter system set undo_retention = 18000;

Show parameter undo_retention;

This article is from the "frequently used documentation" blog, please be sure to keep this source http://yujianglei.blog.51cto.com/7215578/1559646

ORA-31693 ORA-01555 Error