权限不足WhenCreatingaMaterializedViewLog

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.

创新互联主营苍南网站建设的网络公司,主营网站建设方案,重庆App定制开发,苍南h5重庆小程序开发搭建,苍南网站营销推广欢迎苍南等地区企业咨询

• 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)

• If you are creating a materialized view log for a table in another user's schema,
  you must have the CREATE ANY TABLE and COMMENT ANY TABLE privileges (not included
  in the RESOURCE role), as well as either the SELECT privilege for the master
  table or SELECT ANY TABLE.

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 删除

分享题目：权限不足WhenCreatingaMaterializedViewLog
当前网址：https://www.cdcxhl.com/article2/gsgcic.html

成都网站建设公司_创新互联，为您提供关键词优化、微信公众号、企业网站制作、商城网站、网站排名、用户体验

广告

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联