The privileges required to create a materialized view log are directly related
to the privileges necessary to create the underlying objects associated with
a materialized view log.
If you own the master table, you can create an associated materialized view log
if you have the CREATE TABLE privilege (included in the RESOURCE role)
In either case, the owner of the materialized view log must have sufficient quota
in the tablespace intended to hold the materialized view log or must have the
UNLIMITED TABLESPACE system privilege.
物化视图日志一般情况以MLOG$_开头，在dba_objects里查询，可以用
drop materialized view log 删除
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
