ORA-01555：snapshot too old: rollback segment number X with name "XXXX" too small

ORA-01555：snapshot too old: rollback segment number X with name "XXXX" too small

在查询快照的时候

select * from testtable as of timestamp to_timestamp('2023-04-03 22:00:00','yyyy-mm-dd hh24:mi:ss')

提示错误 ORA-01555：snapshot too old: rollback segment number X with name "XXXX" too small

简单来说，就是数据库的undo_retention设置的太小了

调大以后对于后面的闪回数据量的限制就不会那么大了

本栏目推荐文章
• 【解决方案】Error running,Command line is too long
• An improved LSTM-based model for identifying high working intensity load segments of the tractor load spectrum
• 【Leetcode1949. 坚定的友谊】使用MySQL在无向图中寻找{"CompleteTripartite", {1, 1, 3}}这个pattern
• Python中出现"No module named 'requests'"的图文解决办法
• 在Windows上出现"localhost拒绝连接”的问题
• "nginx.conf" E514 : write error (file system full?)
• 加了@SessionAttributes("uid")退出登陆后如何清除session
• cdn引入vue后报错无法识路径 Uncaught TypeError: Failed to resolve module specifier "vue". Relative references must start with either "/", "./", or "../".
• jni Exception in thread "main" java.lang.UnsatisfiedLinkError:
• [Vue warn]: Component provided template option but runtime compilation is not supported in this build of Vue. Configure your bundler to alias "vue" to "vue/dist/vue.esm-bundler.js".

quot too snapshot rollback segmentquot too snapshot rollback too rollback h7-too rollback-only worldaabb too invalid object prometheus ingesting too samples rollback_info rollback_info rollback navicat info rollback-only transaction rollback because