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.

創(chuàng)新互聯主營蒼南網站建設的網絡公司,主營網站建設方案,重慶App定制開發(fā),蒼南h5重慶小程序開發(fā)搭建,蒼南網站營銷推廣歡迎蒼南等地區(qū)企業(yè)咨詢

• 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
當前網址：http://chinadenli.net/article2/gsgcic.html

成都網站建設公司_創(chuàng)新互聯，為您提供關鍵詞優(yōu)化、微信公眾號、企業(yè)網站制作、商城網站、網站排名、用戶體驗

廣告

聲明：本網站發(fā)布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網站立場，如需處理請聯系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經允許不得轉載，或轉載時需注明來源： 創(chuàng)新互聯