ORA-23435: cannot create an updatable ROWID materialized view with LOB columns

ORA-23435: cannot create an updatable ROWID materialized view with LOB columns
Cause: The propagation of LOB data from materialized view sites to the master site requires a primary key on the replicated table. Thus updatable ROWID materialized views that contain LOB columns are not supported.
Action: Create a primary key materialized view instead of a ROWID materialized view. If the materialized view already exists, it can be converted to a primary key materialized view using the ALTER MATERIALIZED VIEW DDL command.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:45

ORA-23435：无法创建具有LOB列的可更新ROWID物化视图,
.原因： LOB数据从物化视图站点到主站点的传播需要复制表上的主键。因此不支持包含LOB列的可更新ROWID物化视图。,
.操作：创建主键物化视图，而不是ROWID物化视图。如果物化视图已存在，则可以使用ALTER MATERIALIZED VIEW DDL命令将其转换为主键物化视图。,
.

aiaiDBA

13718043309

010-86462881

ORA-23435: cannot create an updatable ROWID materialized view with LOB columns

1 个回答

相似问题