-
Exp-00008 with ORA-01555 Using Automatic Undo Management
Dear all,
We have a data warehouse in Oracle 9i database in HP-Unix, it has a 9 GB undo tablespace with automatic undo management and undo_retention=1979345.
When we do export we got these errors:
EXP-00008: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number 4 with name "_SYSSMU4$" too small
EXP-00000: Export terminated unsuccessfully
Since this tablespace is under automatic undo management, any change to it is not allowed. This export is our nightly backup. Is there a way that we can go around to fix this ORA-15555 error? I believe our UNDO tablespace size is big enough and base on formula Oracle recommended, 1979345 is the optimal value for undo_retention.
Any help is deeply appreciated.
Thanks,
Unna
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|