Showing posts with label ORA-12010: cannot create materialized view log on table owned by SYS. Show all posts
Showing posts with label ORA-12010: cannot create materialized view log on table owned by SYS. Show all posts

Wednesday, 15 February 2012

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.