Labels

Friday, June 1, 2018

ORA-31693/ORA-02354/ORA-01555--Expdp error for very huge schema's table

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

No comments:

Post a Comment