REFRESH

REFRESHE is used to refresh a specified materialized view.

Syntax

DBMS_MVIEW.REFRESH (
    mv_name                IN    VARCHAR(65535)
    [, method              IN    VARCHAR(65535) DEFAULT NULL]
    [, refresh_parallel    IN    INT DEFAULT 0]
    [, nested              IN    BOOLEAN DEFAULT FALSE]
    [, nested_refresh_mode IN    VARCHAR DEFAULT NULL]
);

Parameters

Examples

• Independent refresh:

  • Specify only the mv_name parameter.

    obclient> CALL DBMS_MVIEW.REFRESH('mv1');
    

  • Specify the mv_name and nested parameters, and set the value of the nested parameter to false.

    obclient> CALL DBMS_MVIEW.REFRESH(
        'mv1',
        nested=> false);
    

• Non-consistent cascading refresh:

  • Specify the mv_name and nested parameters, and set the value of the nested parameter to true. Do not specify the nested_refresh_mode parameter.

    obclient> CALL DBMS_MVIEW.REFRESH(
        'mv1',
        nested=> true);
    

  • Specify the mv_name, nested, and nested_refresh_mode parameters, and set the value of the nested parameter to true and the value of the nested_refresh_mode parameter to inconsistent.

    obclient> CALL DBMS_MVIEW.REFRESH(
        'mv1',
        nested=> true,
        nested_refresh_mode => 'inconsistent');
    

• Consistent cascading refresh:

  Specify the mv_name, nested, and nested_refresh_mode parameters, and set the value of the nested parameter to true and the value of the nested_refresh_mode parameter to consistent.

  obclient> CALL DBMS_MVIEW.REFRESH(
      'mv1',
      nested=> true,
      nested_refresh_mode => 'consistent');
  

• The following examples show error scenarios:

  • The value of the nested parameter is false, and the value of the nested_refresh_mode parameter is specified. An error is returned.

    obclient> CALL DBMS_MVIEW.REFRESH(
        'mv1',
        nested=> false,
        nested_refresh_mode => 'xxxx');
    

  • The value of the nested parameter is not specified, and the value of the nested_refresh_mode parameter is specified. An error is returned.

    obclient> CALL DBMS_MVIEW.REFRESH(
        'mv1',
        nested_refresh_mode => 'xxxx');
    

  • The value of the nested parameter is true, and the value of the nested_refresh_mode parameter is an invalid string. An error is returned.

    obclient> CALL DBMS_MVIEW.REFRESH(
        'mv1',
        nested=> true,
        nested_refresh_mode => 'illegal string');
    

References

For more information about refreshing a materialized view, see Refresh a materialized view.