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.
回滚段过小 oracle
最新推荐文章于 2022-03-12 23:50:04 发布