-
ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too smal
Dear Friends,
We are facing the following error, while exporting the Database.
ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small
The database is running on 9206 and we are using undo management tablespace. The tablespace size was 12GB prior to the error, and I have increased it to 20GB. The undo retention was 10000 prior to the error and now I have changed it to 900 just to avoid this error while exporting the database.
Is there a way to allocate larger space for these automatic rollback segments example --> "_SYSSMU8$"
Could you please let me know on how to avoid this error.
Thank you,
Nikee
-Nikee
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
|