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.

No comments:

Post a Comment