ORA-12010: cannot create materialized view log on table owned by SYS

ORA-12010: cannot create materialized view log on table owned by SYS
Cause: An attempt was made to create a materialized view log on the table owned by SYS. CREATE MATERIALIZED VIEW LOG attempts to create a trigger on the table, but triggers can not be created on SYS tables.
Action: Do not create a materialized view log on SYS tables.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:40

ORA-12010：无法创建由SYS拥有的表上的实例化视图日志,
.原因：试图在SYS所拥有的表上创建实例化视图日志。CREATE MATERIALIZED VIEW LOG尝试在表上创建触发器，但不能在SYS表上创建触发器。,
.操作：不要在SYS表上创建物化视图日志。,
.

aiaiDBA

13718043309

010-86462881

ORA-12010: cannot create materialized view log on table owned by SYS

1 个回答

相似问题