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 is introduced starting from 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(
IN mv_name VARCHAR(65535),
IN parameter_name VARCHAR(65535),
IN parameter_value VARCHAR(65535))
Parameters
Parameter |
Description |
|---|---|
| mv_name | The name of the materialized view. You can specify the database 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.