The SET_REFRESH_PARAMS stored procedure is used to set parameters for a materialized view refresh job.
Note
For V5.x versions, SET_REFRESH_PARAMS was introduced starting with V5.0.1.
Limitations and considerations
- Currently, only the
max_run_durationparameter is supported. - The target materialized view must have a refresh job configured.
Syntax
DBMS_MVIEW.SET_REFRESH_PARAMS(
mv_name IN VARCHAR2,
parameter_name IN VARCHAR2,
parameter_value IN VARCHAR2)
Parameters
Parameter |
Description |
|---|---|
| mv_name | The name of the materialized view. You can specify the schema name, for example,TEST.MV_SALES. |
| parameter_name | The name of the refresh parameter to be set. Currently, onlymax_run_duration. |
| parameter_value | The maximum running duration of a refresh job, in seconds. |
References
For more information about refreshing materialized views, see Refresh a materialized view.