ERROR:
RA-31693: Table data object "OWNER."DOC_GRP_BLOB" 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 11 with name "_SYSSMU11_583061684$" too small
Cause:
The LOB Retention is not defined properly.
This is confirmed by the queries:
SYS@xx> show parameter undo;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SYS@xx> select retention, pctversion from dba_lobs table_name='DOC_GRP_BLOB'; no rows selectedThe LOB Retention is not defined properly.
SYS@xx> alter system set undo_retention = 2400 scope = BOTH; System altered. SYS@xx> show parameter undo; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ undo_management string AUTO undo_retention integer 2400 undo_tablespace string UNDOTBS1SYS@xx> ALTER TABLE ITC_OAS.DOC_GRP_BLOB MODIFY LOB (DOC_BLOB) (PCTVERSION 10);Table altered. SYS@xx> ALTER TABLE itc_oas.DOC_GRP_BLOB MODIFY LOB (DOC_BLOB) (RETENTION); Table altered.SYS@xx> select retention, PCTVERSION from dba_lobs where table_name='DOC_GRP_BLOB';RETENTION PCTVERSION ---------- ---------- 10 2400