Contents
How do I drop a Mlog table?
To drop a materialized view log, you must have the privileges needed to drop a table. Specify the schema containing the materialized view log and its master table. If you omit schema , then Oracle Database assumes the materialized view log and master table are in your own schema.
Where does materialized view log table stored?
master database
A materialized view log is located in the master database in the same schema as the master table. A master table can have only one materialized view log defined on it.
How do I delete a materialized view in Oracle?
Use the DROP MATERIALIZED VIEW statement to remove an existing materialized view from the database. When you drop a materialized view, Oracle Database does not place it in the recycle bin. Therefore, you cannot subsequently either purge or undrop the materialized view.
How do materialized view logs work?
In an Oracle database, a materialized view log is a table associated with the master table of a materialized view. Rows are automatically added to the Materialized View Log table when the master table changes. The Oracle database uses the materialized view log to refresh materialized views based on the master table.
How do I change the materialized view log in Oracle?
Specify the schema containing the master table. If you omit schema , Oracle Database assumes the materialized view log is in your own schema. Specify the name of the master table associated with the materialized view log to be altered.
What happens when you drop a materialized view?
If you drop a materialized view that was created on a prebuilt table, then the database drops the materialized view, and the prebuilt table reverts to its identity as a table. When you drop a master table, the database does not automatically drop materialized views based on the table.
Can you create a materialized view log for a table?
You cannot create a materialized view log for a table in the schema of the user SYS. Specify the name of the master table for which the materialized view log is to be created. Restriction on Master Tables of Materialized View Logs You cannot create a materialized view log for a temporary table or for a view.
Can a nocache affect a materialized view log?
NOCACHE has no effect on materialized view logs for which you specify KEEP in the storage_clause. The parallel_clause lets you indicate whether parallel operations will be supported for the materialized view log. For complete information on this clause, please refer to parallel_clause in the documentation on CREATE TABLE.
When to use snapshot in place of materialized view?
The keyword SNAPSHOT is supported in place of MATERIALIZED VIEW for backward compatibility. When DML changes are made to master table data, Oracle Database stores rows describing those changes in the materialized view log and then uses the materialized view log to refresh materialized views based on the master table.