Shulou(Shulou.com)06/01 Report--

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)

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.

The materialized view log generally starts with MLOG$_. You can query it in dba_objects using the

Drop materialized view log deletion

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.