Hi,
I'm doing expdp for single big table.
Expdp was triggered with nohup using parameter file. Table size is 1.6 TB
more ECAP2_exptbl.par
dumpfile=EXP_DUMP:expdpECAP2_2019aug_%U.dmp
logfile=EXP_DUMP:expdpECAP2_2019aug.log
filesize=50G
schemas=ECAP2
include=TABLE:"IN ('JBPM_BYTEBLOCK')"
Output log :
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1635. GB
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-31693: Table data object "ECAP2"."JBPM_BYTEBLOCK" 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 8 with name "_SYSSMU8_1462975257$" too small
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Action taken:
I have increased undo_retention from 900 to 2700
show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 2700
undo_tablespace string UNDOTBS1
Any further action i can proceed to complete my export process.
TQ
Abez