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 ORA-01555: snapshot too old

766485May 2 2011 — edited May 5 2011
Hi All -

I've read many forum entries on this, but so far I've been unable to solve my problem. Running on Windows 2003 Server, Oracle 11g 11.1.0.6.0

I'm trying to do an expdp of my entire database. The only process that is running is the expdp. I have shut down all user applications that make connections to the database. There's nothing writing to this table, and nothing reading from it aside from expdp.

. . exported "HDB_MAIN"."WAVEFORM0" 64.64 GB 1811611 rows
ORA-31693: Table data object "USERNAME"."WAVEFORM2" 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_1193973708$" too small

SQL> show parameter undo;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 9000
undo_tablespace string UNDOTBS1

SQL> select sum(bytes) from user_segments where segment_name = 'WAVEFORM2';

SUM(BYTES)
----------
7.7513E+10 # this is about 72GB, the largest table in the database

I increased undo_retention from 900 to 9000, but that didn't make any difference. Since undo_management is AUTO, I don't have control over actually allocating more space to the undo segments, right?

(I've been a DBA before, but less experience with Oracle... )

A few "For what it's worth" items:
the final output file was 328gb without WAVEFORM2. Still 193gb free on target drive after the 328gb output file has been saved there.
oradata takes 946gb
disk free space 42.6gb on oradata drive

Any ideas on what I could look at next?
This post has been answered by Sunny kichloo on May 3 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2011
Added on May 2 2011
7 comments
18,723 views