Oracle DBA, How To, Error, Cause and Action

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

Thanks for your comment.