list_materialized_views
List Oracle materialized views with refresh mode, method, last refresh, and staleness, filtered by schema or LIKE name pattern.
Instructions
List materialized views with their refresh mode, method, last refresh and staleness. Optional schema and LIKE name pattern.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Schema (owner) name. Omit to search all schemas. | |
| namePattern | No | LIKE pattern for the mview name. Defaults to '%'. |