Materialized view attributes
-
Name
The name of the materialized view (MV).
-
Metadata UID
The unique identification number of the materialized view.
-
Audit Compressed
Specifies if the compressed audit-checkpoint messages are generated for Disk Process 2 (DP2) files. The values are On or Off.
-
Clear On Purge
Indicates if the contents of the MV are overwritten when the MV is dropped. If the value is On, then the contents of the table are overwritten when the MV is dropped. If the value is Off, then the contents are not overwritten.
-
Block Size
The size, in kilobytes, of the blocks that compose the file.
-
Refresh Type
The refresh policy of the MV. The value is On Statement.
-
Initialization Type
The time when the MV is initialized with the data of the base table. The value is On Create.
-
Creation Time
The time and date when the materialized view is created.
-
Redefinition Time
The time and date when the materialized view is last redefined.
-
Owner
The owner of the MV.