ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too smal
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.
Click Here to Expand Forum to Full Width