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 fails with ORA-31693 and ORA-01555

SherpaSimonNov 3 2009 — edited Nov 7 2009

Hi,

I am using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi on hp-ux

I am exporting the DB as follow :

expdp system/password \
full=y \
dumpfile=backup_dir:expdp_$ORACLE_SID.dmp \
logfile=backup_dir:expdp_$ORACLE_SID.log \
exclude=statistics \
estimate=statistics \
flashback_time=\"TO_TIMESTAMP$\'$DATE_EXP\', \'YYYY-MM-DD HH24:MI:SS\'$\"

it always worked fine but this morning I received an error message :

ORA-31693: Table data object "DFE"."TGV_CONTROLE" 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 1 with name "_SYSSMU1$" too small
ORA-00604: error occurred at recursive SQL level 3
ORA-08180: no snapshot found based on specified time
ORA-06512: at "SYS.TIMESTAMP_TO_SCN", line 1
ORA-00604: error occurred at recursive SQL level 3
ORA-08180: no snapshot found based on specified time

any idea of what may causes this error ?

thanks

This post has been answered by Toni Lazarin on Nov 3 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2009

Added on Nov 3 2009

#database-key-features, #export, #export-import-sql-loader-external-tables, #oracle

3 comments

5,506 views