本文介绍了解决尝试使用 SYSTEM 回滚段进行非系统表空间操作时遇到的问题的方法。建议创建一个或多个回滚段，并通过 ALTER ROLLBACK SEGMENT 命令将其设置为在线状态。可能还需要修改初始化参数 ROLLBACK_SEGMENTS 以获取新的私有回滚段。
Cause: An attempt was made to use the SYSTEM rollback segment for operations involving a non-system tablespace.
Action: Create one or more rollback segments and then use ALTER ROLLBACK SEGMENT 'name' online. It may be necessary to modify the initialization parameter ROLLBACK_SEGMENTS to acquire one of the new private rollback segments. Before creating a rollback segment outside the SYSTEM tablespace, it is necessary to first create and activate a non-system rollback segment in the SYSTEM tablespace
Action: Create one or more rollback segments and then use ALTER ROLLBACK SEGMENT 'name' online. It may be necessary to modify the initialization parameter ROLLBACK_SEGMENTS to acquire one of the new private rollback segments. Before creating a rollback segment outside the SYSTEM tablespace, it is necessary to first create and activate a non-system rollback segment in the SYSTEM tablespace
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
