Skip to Main Content

Oracle Database Discussions

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!

Help with ORA-01555: snapshot too old during EXPDP

3404766Oct 6 2017 — edited Oct 7 2017

I have a 620 GB table that i am trying to export that keeps erroring out with snapshot too old error

My undo retention parameter is set to- 64800

Parameter file is below (names blanked out for security)

directory=##

dumpfile=##U.dmp

logfile=##.log

tables=##

parallel=26

EXCLUDE=STATISTICS

COMPRESSION=ALL

CONTENT=ALL

DIRECT=Y

CLUSTER=N

filesize=50G

flashback_time=systimestamp

Undo advisor says that I need to increase my undo space to 800 GB from the current 200 GB which is not possible so looking for any suggestions

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2017
Added on Oct 6 2017
11 comments
2,119 views