Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Expdp error with snapshot too old

abezAug 20 2019 — edited Aug 29 2019

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

Comments
Post Details
Added on Aug 20 2019
9 comments
9,933 views