expdp导库的时候,日志提示:
ORA-31693: Table data object “*** " . " ***” 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 with name “” too small
ORA-22924: snapshot too old
可以通过先改大retention的时间,然后修改lob列的rention:
alter system set undo_retention=1800;
alter table tab_name modify lob(col_name)(retention);
这里需要注意一下,undo_retention影响新建的表,新建的表会自动的调整retention为undo_retention的参数大小,而原本存在的lob列,需要手动修改。