Audits for Materialized Views

You can run DDDAUDIT queries to check for materialized views to resolve any inconsistency in the database:

• MVIEWS-1

• MVIEWS-2

• MVIEWS-3

See the section Materialized View Queries [Oracle] for detailed audit queries.