Purpose
This statement is used to drop a materialized view log.
Note
When dropping a materialized view log, if the base table is involved in an ongoing transaction, the drop operation will be blocked until the transaction completes.
Privilege requirements
To drop a materialized view log, you must have the DROP TABLE privilege. For more information about privileges in OceanBase Database, see Privilege classification in Oracle mode.
Syntax
DROP MATERIALIZED VIEW LOG ON [schema.] table;
Parameters
| Parameter | Description |
|---|---|
| schema. | Optional. Specifies the schema of the base table of the materialized view log. If you omit schema., the base table is assumed to be in your own schema. |
| table | Specifies the name of the base table corresponding to the materialized view log. |
Examples
Drop the materialized view log on the test_tbl1 table.
obclient [SYS]> DROP MATERIALIZED VIEW LOG ON test_tbl1;
The return result is as follows:
Query OK, 0 rows affected