ORA-12039: unable to use local rollback segment "string"

ORA-12039: unable to use local rollback segment "string"
Cause: A local rollback segment was specified in the CREATE MATERIALIZED VIEW command, but automatic refresh parameters were not specified. Therefore a refresh group was not created to automatically refresh the materialized view and the local rollback segment can't be registered for future use.
Action: Either supply the automatic refresh parameters so that a refresh group will be created or do not specify a local rollback segment.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:40

ORA-12039：无法使用本地回滚段“ string ”,
.原因：在CREATE MATERIALIZED VIEW命令中指定了本地回滚段，但未指定自动刷新参数。因此，未创建刷新组以自动刷新物化视图，并且本地回滚段不能注册以备将来使用。,
.操作：提供自动刷新参数，以便创建刷新组或不指定本地回滚段。,
.

aiaiDBA

13718043309

010-86462881

ORA-12039: unable to use local rollback segment "string"

1 个回答

相似问题