Delete a Materialized View Definition

Note: Materialized view functionality is disabled by default. To enable, contact technical support for assistance. The Materialized Views API is deprecated and will be removed in a future release.

Important: This is an experimental feature.

Deleting a materialized view does not affect the underlying pre-aggregated data. When that data is not used any more, it should be deleted manually from you external storage by the data owner.

Delete a materialized view definition using the UI

1. Make sure you are logged in as a user with the Administer Sources  privilege or that you have read, write, and permission for the data source.

2. List the materialized views for the data source. See List Materialized View Definitions.

   

3. Locate the materialized view definition you want to delete and select in the Delete column for the definition.

   A warning dialog appears, prompting you to confirm the deletion.

4. Select Delete on the warning dialog.

   The definition is deleted.