Get all materialized view logs

get

/database/objects/materialized_view_logs/

Returns all records from DBA_MVIEW_LOGS or ALL_MVIEW_LOGS view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.

Request

Supported Media Types
Query Parameters
  • The maximum number of records to return.
  • Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.
Back to Top

Response

Supported Media Types

200 Response

All records from DBA_MVIEW_LOGS.
Body ()
Root Schema : DatabaseObjectsMaterializedViewLogs
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : DatabaseObjectsMaterializedViewLogsItem
Type: object
This object describes a materialized view log in the database.
Show Source
Nested Schema : LinkRelation
Type: object
Show Source
Back to Top