回滚段过小 oracle

最新推荐文章于 2021-04-06 07:52:21 发布

hanchaohang

最新推荐文章于 2021-04-06 07:52:21 发布

阅读量757

点赞数

CC 4.0 BY-SA版权

文章标签： Oracle SQL

本文链接：https://blog.youkuaiyun.com/hanchaohang/article/details/83938185

ERROR at line 1:
ORA-01562: failed to extend rollback segment number 4
ORA-01650: unable to extend rollback segment R03 by 640 in tablespace RBS1
ORA-06512: at "SYSTEM.PREFORMANCETESTTING", line 14
ORA-06512: at line 1

解决方案:
将回滚段设置为无限大

SQL> alter rollback segment R03 offline;

Rollback segment altered.

SQL> alter rollback segment R03 storage (next 10m maxextents UNLIMITED);

Rollback segment altered.

SQL> alter rollback segment R03 online;

Rollback segment altered.

SQL> commit;

Commit complete.