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.