ORA-31693 ORA-01555錯誤

oracle10g用資料泵導出資料提示，提示錯誤如下：

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

解決方法如下：

show  parameter   undo_retention;檢視該變量的值

SQL> show  parameter  undo_retention;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

undo_retention                       integer     900