Error
=====================================
ORA-31693: Table data object "XXXXX"."XXXX" 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 51 with name "_SYSSMU51_2713117374$" too small
======================================
Solution:-
===============
1. Increase the undo_retention period.
ALTER SYSTEM SET UNDO_RETENTION = 14400;
Please not this is dynamic, hence you can change anytime.
2. use parallel option during expdp command.
dumpfile=XYZ.dmp
logfile=XYZ.log
schemas=SAM,RAMIES,KSIS
directory=DATAPUMP
flashback_time=sysdate
parallel=4
=====================================
ORA-31693: Table data object "XXXXX"."XXXX" 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 51 with name "_SYSSMU51_2713117374$" too small
======================================
Solution:-
===============
1. Increase the undo_retention period.
ALTER SYSTEM SET UNDO_RETENTION = 14400;
Please not this is dynamic, hence you can change anytime.
2. use parallel option during expdp command.
dumpfile=XYZ.dmp
logfile=XYZ.log
schemas=SAM,RAMIES,KSIS
directory=DATAPUMP
flashback_time=sysdate
parallel=4
No comments:
Post a Comment