ORA-01552: cannot use system rollback segment for non-system tablespace 'string'

ORA-01552: cannot use system rollback segment for non-system tablespace 'string'
Cause: Tried to use the system rollback segment for operations involving non-system tablespace. If this is a clone database then this will happen when attempting any data modification outside of the system tablespace. Only the system rollback segment can be online in a clone database.
Action: Create one or more private/public segment(s), shutdown and then startup again. May need to modify the INIT.ORA parameter rollback_segments to acquire private rollback segment. If this is a clone database being used for tablspace point in time recovery then this operation is not allowed. If the non-system tablespace has AUTO segment space management, then create an undo tablespace.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-01552：不能使用系统回滚段非系统表空间' string ',
.原因：试图对涉及非系统表空间的操作使用系统回滚段。如果这是一个克隆数据库，那么当在系统表空间外尝试任何数据修改时，这将发生。只有系统回滚段可以在克隆数据库中联机。,
.操作：创建一个或多个私有/公共段，关闭然后再次启动。可能需要修改INIT.ORA参数rollback_segments以获取私有回滚段。如果这是用于tablspace时间点恢复的克隆数据库，则不允许此操作。如果非系统表空间具有AUTO段空间管理，则创建undo表空间。,
.

aiaiDBA

13718043309

010-86462881

ORA-01552: cannot use system rollback segment for non-system tablespace 'string'

1 个回答

相似问题