CHANGE_REFRESH_EXCLUDE_RULE

Changes an exclusion rule for SCURTY refreshes that was added using procedure add_refresh_exclude_rule.

Rules can identify DDL event types, object types or database objects. For example, a rule may exclude refreshes for the creation (event type) of tables (object type) whose names start with “ADM…”.

This procedure updates a row in table REP_REFRESH_EXCLUDE.

Parameter Name	Required	DefaultValue	Values	Description
p_rule_number	yes			The value of column RULE_NUMBER used to identify the rule that to be updated in table REP_REFRESH_EXCLUDE.
p_ddl_event_pattern	no			A regular expression that matches one or more DDL events. Possible event types to match are: ALTER CREATE DROP RENAME COMMENT If a NULL value is provided or the parameter is omitted, the existing pattern remains unchanged.
p_object_type_pattern	no			A regular expression that matches one or more object types. Possible object types to match are: TABLE VIEW SNAPSHOT COLUMN If a NULL value is provided or the parameter is omitted, the existing pattern remains unchanged.
p_object_owner_pattern	no			A regular expression that matches one or more object owner names. If a NULL value is provided or the parameter is omitted, the existing pattern remains unchanged.
p_object_name_pattern	no			A regular expression that matches one or more object names. If a NULL value is provided or the parameter is omitted, the existing pattern remains unchanged.
p_rule_comment	no			A comment regarding the rule. If a NULL value is provided or the parameter is omitted, the existing comment remains unchanged.

Example

The following statement changes rule number 1 to not trigger SCURTY refreshes if the object owner schema name starts with ‘ADM’ or ‘EXP’. All other parameters are not provided in the procedure call and hence will not be changed:

EXEC p_rep_admin.add_refresh_exclude_rule
    ( 1
    , p_object_owner_pattern => 'ADM.*|EXP.*' );